Search results

I have a database that I have created a nice switchboard for. My problems lies in the fact that I would like the switchboard have a button to automatically backup the database instead of selecting that option through the tools dropdown menu. I assume that if I can perform that task that other...

I got it runing......Thanks to all who helped...:) JC

Here is the code for the Inputform located in the Search under the After Update: Option Compare Database Option Explicit Private Sub Form_GotFocus() DoCmd.Maximize Me.Form.Requery Search = "" License = "" DoCmd.GoToRecord , , acNewRec Me.Search.SetFocus End Sub Private Sub...

wiklendt, 1) I have placed all the screens to the left and towards the top so that the client (myself and a couple of folks) can use it on the computer at work that is set at 800x600. I hope that this will not bother you when trying to help. 2) The colors I have chosen are working fine on my...

I was hoping that both these problems wre related since they are happening in the same form and subform...Maybe someone could give it a quick look over and head me in the right direction... Thanks JC

I have a databae that I would like help in cleaning up the code. When I open up the database using the Splash screen, it is working fine.....Hitting OK takes me to the Switchboard....where everything is working fine....;) In the Form button and then the Edit/Enter License Data it opens up to my...

I have a databae that I would like help in cleaning up the code. When I open up the database using the Splash screen, it is working fine.....Hitting OK takes me to the Switchboard....where everything is working fine....;) In the Form button and then the Edit/Enter License Data it opens up to...

That seems to be working fine even though a new record is displayed with the information in it. I guess it doesn't save it if the other fields are blank which is good. Thanks for the insite!;) JC

I have a db that has a main form and a subform. I want to ask the user for a date that they are working on...and then have that date automatically inserted into the subform field so they don't have to continually retype it. As with my other field, I need to have them asked what checkpoint they...

DK, hav pondered and tried to foloow your examples....i can get the new database, query, and reports up and running....but when i do the update to in the query....my database falls out of alphabical order.....:( can you advise me on how to keep it alphaetically sound? Thanks...I have the...

that is a lot of information....to take in and process....this will take some time...but it looks like you have put me on the right trail...:) you have the input for how many times they have been to the garage and have listed them someplace.....is that a table you creat each time???? as i am...

Still having problems....i have looked over your files and am sending database to ya for a good look over... ok got it to upload...as you can see i am still working on it...but you can play with it and see what you can come up with.... again i am working with 2003 and would like to have the...

Still having trouble getting any info out of the database in any kind of workable print. I can print out all the recordswhen I use the wizard for reports....but i don't want all that data...just the records that have more than what the operator wants to print out...Say I want to print out all...

A common mode is to create something like .. MainTable: pkMainID (Autonumber) and ChildTable: pkChildID (Autonumber), fkMainID (Long) and let the primary key (pk) and foreign key (fk) provide the linking and let Access do all of the work. WOW!!! I guess I need to revamp my database...only...

I have read, pondered and tried several things, but I guess I still don't get it. Your links are really good and I will use them in the future, but I can't seem to get my problem fixed. These are the Mainform (InputForm) Fields: VehicleID AutoNumber License Text State Text Make Text Model...

Thanks DK...I am in the process of reviewing all the links and hopefully learn somthing....and I hope I cn put them to use.... Thanks again! JC

I have taken a few programming languages in the late 70s, so it has been a long time for coding. Being relatively new to Access, I am not sure where to put that code or how to use it in the query wizard. Gentle guiding is needed.:( Thanks JC Willette

I have a main form that has license plates with a subform that has the dates they were in our garage. I would like to print a report out with a variable that will count the number of records each license plate has and print out the ones that are over the variable.;) So let's say I want to...

I have a database that has 2 forms, one ain form and a continuous subform displayed on the same screen. I am able to search for a record and display the results for that record in the main and sub forms, but I have to tab trhough all the fields on the main form to get to the subform. :( What I...

Thanks for all those who helped me out. I still have a couple of problems in my coding for the main and sub forms. Any help would be apprceiated. Here are my Input Form Fields: VehicleID AutoNumber License Text State Text Make Text Model Text Type Text Color Text Code 4 Yes/No Box These...