Search results

To rak: I found that same thread when I did my search. The "Cool Search Database" is a great search tool, but it still uses a query for the search form. The problem isn’t that I don’t know how to build query’s and search forms, it that a query is limited to the amount of tables you can...

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...

Thanks Joe, I found what I was looking for. = Environ$("USERNAME") Inserted in the default value of a text field. gMAC.

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

Thanks, I'll give it a try. gMAC

What I wanted was both A and B. I placed the OR in the Areaname2 of my search code and left Areaname AND. When I tried it, it did return both. The full search code has many more search fields that are tied with the AND. The rest of the code works fine except the between dates part. If Not...

The OR worked, so simple. Thanks gMAC

Thanks for the reply, tried the space but still will not work. I think it has something to do with having two search parameters for one field. Here is an example of the search string the code creates. [Date]>= #12/01/2005# AND [Date]<= #12/29/2005# and [AreaName]= "Power"and [AreaName]=...

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...

Instead of making a new form, you could place a large textbox over some of your existing controls, then in the Property’s Box under Format select No for Visible. Next create a new command button, in the On Click event place this code for your textbox, Me.YourTextbox.Visible = Not...

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...

Of course, I don't know why I did'nt think of that. Thanks gMAC

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...

Thanks, I'll give it a try. gMAC

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, ...

Wow!! Thanks Jon K, I've been trying to figure that out for three days! It's much appreciated. ~gMAC~

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)...

Here's one site you can try. http://www.rogersaccesslibrary.com/TableOfContents.asp ~gMAC~

This will only work with the current record. If you look at my first post, Mr. Jones checking out of A-17 is a seprate record from Mr. Smith Checking in to A-17. Me.DateIn = Me.DateOut will only compare the to fields in the same record. But thanks for trying. ~gMAC~

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...