Search results

To delete a record, I use: DoCmd.RunCommand acCmdDeleteRecord I want to run some code before it. Ie: Delete the student out of the library table (cant be bothered typing the code) Then: DoCmd.RunCommand acCmdDeleteRecord 'Deletes the student out of the student table The problem is that it...

So why not have: tblRides:IDride (key), datefrom (key), timefrom (key), dateto, timeto, mileage, IDplace (fk) tblwaypoints: IDplace (key), placename, county ie: Ride no1, 10/07/2003, 10:00am, 10/07/2003, 11:00am, 10km, Place1 Ride no1, 10/07/2003, 11:00am, 10/07/2003, 12:00pm, 10km, Place2...

This is what I do... I have created a simple login form which loads on start up. It has a text box for the username (txusername) a textbox for the password (txpassword) a button to login and a button to exit. When you click the login button, the following code is run: password =...

Each user belongs to many programs. Their string is as follows: "'Accounting','Marketing','Finance'," Now items belong to certain groups. Like a vehicle belongs to the accounting program. Its easy enough to see if a user belongs to a program WHERE userprogram like '*" & textbox & "*' And...

Thank you.

I have three item booking screens: vehicle, room, equipment. The table fields are identical. What are the pros and cons of having them in three tables, or having them in one table, with an extra field called "type"? I imagine if they are in one table, access has to sort through 300 records...

In the report screen: I want each record to be displayed on a single page. Is this possible? Also, if data is too big for that record, it might go on to a second page. I dont want the next record to start until it is a new page. ie: Page 1 = record 1 Page 2 = record 2 Page 3 = rest of record...

What I do is set them on and off using Visual basic code. That way you can turn everything off to minimum, and when you need to edit your database, turn them all back on. Sorry about the bad code. I got it straight from the help page and I havent really read it, or formatted it. All I know is...

I use the following code Set rst = CurrentDb.OpenRecordset("SELECT * FROM table;") With rst .Delete End With The problem is, this only deletes the first record. Whats the best way to loop this/do this? (shortest code possible)

Create textbox 1 and textbox2. Under the properties make both locked (true) and enabled (false). The label for the first one can be "Manufacturer", and the label for the second one can be "type" or whatever. Create a combobox1, and using the wizard, select the manufacturer from the table...

OK, I dont know your level of knowledge so feel free to ask any questions: You have two combo boxes: Combo1 and Combo2 What you need to do is in the "after update" code for Combo1, have: Combo2.rowsource = "SELECT type from table WHERE manufacturer = '" & combo1 & "';" Does this help/make sense?

OK, this is when I become a total noob.... Um, how do you create forms, queries, reports etc... for tables that arent in the same database?

I changed it so the userstring read "'marketing', 'accounting', 'finance'" It works perfectly...So far... Thank you for your help

If there are 20 or more users using your access file, problems can start. Also, if you want to update your front end, then you must lock all users out of the database. For this reason, alot of people use asp, asp.net, or even visual studio (I think). That way when the application needs...

What are the best front end application options I should investigate? I have heard that many choose asp or asp.net. What do other people use?

Im getting really close now... What about SELECT program FROM program WHERE program NOT IN ('" & me.userstring & "'); where the UserString = "Accounting;Marketing;Sales"

Um...Not quite. Let me try to explain again. In one table are the numbers 1, 2, 3, 4, 5 The user has a string "1, 4, 5" Now I want to create the row source for the combo box (via VB) to have the options 2, 3. ie: row source = "SELECT number FROM number WHERE number NOT IN (select...

I have a database where there are many programs. ie: Accounting, Marketing, Business etc... The user's valid programs are listed like this "Accounting, Marketing" This is stored in the staff table. When I run the following: DLookup("program", "program", "program IN(select program from staff...

My database is going to be limited, and practically has no menus. How can I do the following with the help of visual basic? When you click on a text button it compacts and repairs the database. (I had a look in the help file but the help page describing this was missing !) Thank you

Or you can right click the file and choose send to ---> desktop