How To Create Users In Form
hey guys,
i just needed a guide on how to create a form with different users in it.
also, is there a way in which i can create a button that will open the wizard to create a report ??
[guess wat, no deadline.... but that doesn't mean dont answer ;) ]
hope a reply soon..
thanks in advance.
View Complete Forum Thread with Replies
Related Forum Messages:
Interface To Allow Users To Create Ad-hoc Queries
Hi All I'd like to implement something in an app to allow users to create their own ad-hoc queries from a specific number of fields from specific tables, without allowing them full access to the query designer. I can see how to do it (a form with code that creates the SQL), but I wondered if anyone had done something like this before and had any tips or even any existing code. Have searched and can't find anything, but I suspect I'm searching on the wrong keywords. Dave
View Replies !
Form With 3 Users
Hello, Question 1: Is it possible to use the same form, from the access database on the server, working with 3 users on 3 different pc's? Question 2: How can I send data, wich is in the cells of an Excel file, to an Access database in a table? I have a machine that put data in an Excel-file without opening. Because I want put the data in Access I want automatically, done by VBA, send the data from Excel to Access without opening Excel. Is this possible? greetings, mulderm
View Replies !
Multiple Users In Same Form
There will multiple users accessing the same database/forms at the same time. How do I ensure that all entries are saved and not overridden by each other entries? Access 2003
View Replies !
Password Form For Multiple Users
I am not sure how to do this. I am trying to do up a password form where there is a user name and a password. There will only be 5 user names, one being an admin. I seen it in the Running Microsoft Access 2000 book (it's just a reference manual) but could not figure it out.
View Replies !
Users Entering A New Record Through A Form?
Hello! :rolleyes: Just need a little extra help :( I have set up a form for the user to fill in a new record and used a command button for it to save. This all works ok. The problem I have is when the form is opened, a record is shown in each of the fields as opposed to a blank one. The user can still enter data but they need to delete the stuff that is already in the box. The user then, will have to press the little star at the bottom. I have tried going into to design view, and typing in "Unbound" but it came up with #name? ... can anyone help me ? Shellie x
View Replies !
Question About: A Table Of Users Who Have Relationships To Other Users??
Hi, I have a table of users somthing like this: User_ID Name Hobby Favorite_Food Blah Blah Blah Users can be friends with one another and I need some way of logging this. My 2 options (that i can see) are: 1) Putting a friends entry in the main user table then comma delimiting the User_ID's in the friend entry like so: User_ID: 001 Name: John Hobby: Frizbee Favorite_Food: Cake Friends: 002,004,010 2) Making a seperate table with multiple entries for each user like so: User: 001 Friend 002 --- User: 001 Friend: 004 --- User: 001 Friend: 010 --- User: 002 Friend: 001 --- User: 004 Friend: 001 --- User: 010 Friend: 001 --- The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's. But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table. My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice. Thanks.
View Replies !
Access To A Database Form For More Users At The Same Time
Hi, I created a database where everybody should insert his holiday plans and absence of business. the Database is linked and opens automatically the form when you click on the link on the pdf. But know it is not possible anymore that more than one person opens the file to insert the data. The mistake is: Could not lock file! What do I have to do that more people can use the database at the same time (not only read-only) Thank you for the help
View Replies !
Create Form From Wizard
During the create form from wizard process, there is a screen which gives the option of applying a style. Can this be bypassed or can a 'none' option be added.I'm new to access, so any suggestions are welcome. I think creating a form in design view will build with no syle, but how do you add fields?thanks
View Replies !
How To Create A Form As An Executable
hi everyone i'm super new at access. i think it's neat for now. i just made a form that people can use to insert information. we have a network drive here and it would be super cool to be able to convert the form into an Executeable file that way people can just click on the exe Icon and open up the form without having to go into access and then open the form. please let me know
View Replies !
Create A Chart On A Form
i have about 1500 records in my database and i want to display a bar chart for each record, i can tryed creating one but when i try adding the months it says i only can add 6 fields but i want to include each month not just 6 months in the chart, this is an on going database so in the future there will be more months added. here is the picture of the form i want to be able to show 2005 and 2006 figues in the same chart
View Replies !
Create Records From A Form
Can someone direct me as to the most efficient way to add records to a table from a form? I have a table of members and a table of invoices and want to automatically create an invoice for each member by clicking a button on a form. Is there a way to do this using a macro, query, or do I write it in VBA? Thanks much!
View Replies !
Need To Create A Form Letter....
I need to add a basic button on a form that would populate the current on-screen data in a form letter. The fields I have are name, address, city state zip and amount. I currently have the basic buttons on my form - Search, Next, Previous,Add, Delete Print Current Record. Thanks in advance for your assistance.
View Replies !
Create New Record With Form
How do I create a new record (in the table to which the form is bound) automatically if, when the form opens, there is no record in the table that meets the criteria in the form filter? Thanks!
View Replies !
Help- Create Search Form
hello, i know i have seen example from here, nome of them seems to help. My is just a simple search. i have 4 tables: Artist Name, title, country and location all i want is create a form that has a search. I want to type the artist name and it lists the country of the artist. How to i do this. I create the command button and text box but it just does not work. This is the code i use on the command. Quote: Private Sub ButtonSearchForRecords_Click() Dim StringQuery As String Dim StringWhere As String StringWhere = "" If Not (TextBoxSearchName = "") Then StringWhere = StringWhere & "AND [Name] = '" & TextBoxSearchName & "' " End If StringWhere = Right$(StringWhere, Abs(Len(StringWhere) - 4)) StringQuery = "SELECT [Name], [Title], [Country], [Location] " _ & "FROM [2-75TH SCAR] WHERE " & StringWhere _ & "ORDER BY [Name], [Country]" Me.ListBoxRecordsFoundInSearch = StringQuery Me.ListBoxRecordsFoundInSearch.Requery End Sub
View Replies !
|
TRACKER
