Search results

No really, it did. Ok so here’s my problem. I inherited a database used for testing. Field techs enter test data in the database out in the field, come back to the office and load the data to a backend database on a server. The secretary’s print out the reports to send to customers. This...

I have a split database (A2000) on a server; many people use the database at many different terminals. I would like to save the computers identification to the record being created. Any ideas on how to accomplish this? Thanks gMAC

I am by far no code writer but can muddle my way through (sometimes). I have built a search form with date span, combo and text boxes for the search. I found this code from a demo database posted on another web site and modifided it for my use. It works great except I need to search one field...

I have a large database with over fifty forms for data entry. On each form I have a button for creating a new database to be E-mailed to a customer. This code works great but I would like the newly created database to open with the report opened and maximized. Sample of code. Private Sub Make...

I have a command button on my form that creates a new database and places it in a seperate folder for Emailing data. During the day I may have created many new databases. I also have a comand button for deleting all the database's in the folder after they have been Emailed. (I'm using the Kill...

I found this code (thanks to this forum) and it works great! Sub CreateNewDB() Dim wsp As Workspace Dim dbs As Database Dim strDBFile As String strDBFile = "C:\NewDB.mdb" Set wsp = DBEngine.Workspaces(0) Set dbs = wsp.CreateDatabase(strDBFile, dbLangGeneral) DoCmd.CopyObject strDBFile, ...

I'm building a booking database that requires many reports. One report need to show what rooms and dates the rooms are available. I need a query that will return dates the rooms are not booked. Put simply if room A-1 was rented 1/5/03(InDate) to 1/10/03(OutDate) and then rented 1/14/03(InDate)...

Access 2000: I'm building a report for room booking database, the report will show check in and check out dates based on a between dates parameter query. So the report will show the room number, checking in date and checking out date. Exp: Mr. Jones - Room A-17 - Check In 12/2/02 - Check Out...

I created a simple database to track employee’s vacations. One table with EmpName, Vacation1, Vacation2, Vacation3, ect. Employees can have up to six week of vacation depending on there time with the company. With over a 100 employees our company will only allow so many employees off per week. I...

I've created an access database that has hidden menu's. I would like to place filter command buttons on my forms (that operate like the ones on the menu bar. However the ones generated by the wizard do not work the same. I've also tried changing the code on the buttons useing the...

I built a form (Access97) with date fields and part number fields. When a part has been replaced in the equipment, I need to track the expense. To simplify data entry I used Dlookup (After Update) to lookup a price from a parts price table. This works great, but my problem is if someone enters a...

I have a form that has approx. 50 textbox fields that display the prices of parts. All of these field names end in Prs, (Table1Prs – Table50Prs). I would like to have a text box displaying the total of all 50 boxes. I know you can use =[Table1Prs]+[Table2Prs]+ect. this would be very long. Can...