Search results

Hi The users of my database are entering some data, all in uppercase, some in lowercase, and some mixed. This makes the text in the combo boxes etc. look bad. Is there a way that I can set the format so it will always display the first letter of each word in uppercase? Thanks Tom

Wjoc1 This is an example; 'this references the main form Forms!YourMainFormName You may have to get the focus away from the subform, before you can reference it. DoCmd.GotoControl Me!SomeControlOnYourMainForm 'this references the subform Forms!YourMainFormName![YourSubFormName].Form...

Gguy You need to run a requery in your after update property of your agencyID. Me!SubFormName.Requery That should fill your subform everytime you make a change. It might work for you to add another subform with your address info. Tom

Kermit5 Try this. 1. Your 'Picture table' should have three fields. PictureID (autonumber) Style (text) Picture (ole) 2. Now back to your 'Bound Object frame' properties Control Source =DLookUp("[Picture]","Picture table","[Style]=[cmbLockTrimStyle]") 3. In your...

Kermit5 You probably should make a table for your lever pics. (ole objects) Store the pics in the table. When the combo box selects a certain lever, you can use code or a macro to fill your picture box with the specific pic. eg. in the 'on change' event of the combo box Private Sub...

Hi I have code that unlocks my invoice form when it opens to a new record. If the user changes his mind and navagates back to the previous record the form is still unlocked. How can I code the form to lock again? Thanks Tom

I have a switchboard where I open my report selector form. When I choose a report the code opens the report and closes the report selector form. I don't want the switchboard to close, so it is left open all the time. The trouble I have is that when the report opens it is hidden by the...

Hi, I want to run a Requery on a list box that is on a Tab. I have done sub forms before, but I can't seem to get this tab to work. I tried [forms]![form1]![Tab1]![ListBox] but it doesn't work. Tom

Your list of reports should live in a table. The table would have three columns; ReportID, Report Catagory, and Report Name. Your combo box should run from a query that accesses that table. If you have three catagorys for reports, add three radio buttons on your 'Report Selection Form'. Have...

Cuttlerhammer You could imbed a subform on your form, that would hold the tasks. you would also make a relationship between your tasks and employees. You could also insert code in the 'on open' property of the form, that loads the task with todays date. Hope that helps a little. Tom

Sorry Bob. Typo, the form is open for two seconds. The form isn't doing anything except looking good. Its all about looks. What I want is for the progress bar to fill while timing out the form. It should appear as though something is being loaded. How do I do this? Tom

I have a splash form that opens for two minutes when my database opens. I want a progress bar on the form to be zero when the forms opens and fill to be full when the splash form closes. I have put an active x progress bar on the form but I have no idea how to make it work. help Tom

Richio You will find there are many conflicts while running both versions. What you could do is un-install 97. Do your database in 2000 then got to your menu, select 'tools' - 'database utilities' - 'convert database' - 'to prior database version'. Then save the database. It should then be a...

Thank you both for your reply, but I still don't get it. Tom

I have an idea that would make my lists easier to read. If line 1 had a white background and line 2 had a yellow background and line 3 had a white background again line 4 yellow again, and so on. I would like to do this in my forms and in reports. Does anyone have coding ideas to accomplish...

This is worth a try. Go to your 'Tools' menu Then 'Database Utilities' Run the 'Compact and Repair Database...' If that doesn't do it defrag your hard drive and run your windoctor. As a last ditch attemp, you could run your Microsoft Office install cd. There is a 'Repair' fucntion. This takes...

Hi I want my form to open with the cursor in a subform text box. I am trying to use vb code in the on open event. Thanks Tom

Something you could try is make a query using the two tables, then relate the form to that query. Tom

What happens is the debugger starts and the line that is hi-lighted is the "close" command. I tried the extra form idea and still the debugger starts when the code comes to the line that closes the first form.

I want to refresh the list in my "Customers" combo box. The "Customers" combo box is on my main form. 1.I open the Customer form and add a new customer, with the main form still open. 2.I close the Customer form. 3.When I check the "Customers" combo box I DO NOT find the new customer. What is...