Search results

Can you use VB to set the Application Title Bar? I have looked at the SetOption code, but do not see anything for Application Title Bar.

This is typical, the Dlookup and other commands i.e. format, etc.. use an old MDAC. Your users probably have newer versions. You can try giving them the latest MDAC from Microsoft or, I highly recommend packaging with Windows XP Developers toolkit and distributing a run-time version (MDE).

What you need to do is to add a custom menu bar to the front end that will have a command that launches the form you want. You associate the custom menu bar to the application by using the Startup option.

You need to create a summation query on the overtime table. You can sum by employee

Why do you need to split the database?

What's the exact error message?

when you use the open report command, use the filter for the dates and building. DoCmd.OpenReport "Report Name", , ,"ReportDate >= #" & me.begindate & "# AND ReportDate <= #" & me.enddate & "# AND BuildingField = " & me.building & "

It sounds to me that the 2nd and 3rd forms should really be sub forms of form1 and linked. Once they are sub forms, you can refer back to the name on the main form (form 1) as the default.

The same code you used for the main form should be used for the sub form If Me.Arived = True Then Me.[Purchase Sub subform1].Form.AllowEdits = False Me.[Purchase Sub subform1].Form.AllowDeletions = False Me.[Purchase Sub subform1].Form.AllowAdditions = False Else Me.[Purchase Sub...

IMO, thank you. This is just what I needed. I have already start digging into the code

IMO, thank you. This is just what I needed. I have already start digging into the code.

I have seen posts referencing sample code that documents creating dynamic column headings with a cross-tab query. I can not however find the Sample9.MDB database that is referenced in the Microsoft site. Does anyone know where I can find this? It is a sample database specifically for developers.

This can not be done in a list box. You will probably have to use a subform where the list is one field and their will be another unbound field that you will have to populate as the user clicks each option. You will probably also need to give the user a CLEAR button to clear the numbers.

If you use the DOCMD to open the form, there is an option to open the form HIDDEN. And if it takes a long time to load, I would not let the user close the form. I would have a close button, but when the button is clicked, I would hide the form and not close it.

This allow default shortcut menu is already checked. Also I need to add, we are running the MDE of the database using MS Access runtime.

On a deployed application, right clicking is not functioning. We did allow shortcut menus, but the options that usually come up for right clicking (sort, filter, etc..) does not come up. In fact, nothing happens except the column you right click on gets highlighted. We also need the...

You may also be able to use the command rs.findfirst ([Field Name] = '" & rs![PersonID] & "'")

You can use this code for the command button If me.form.dirty then me.form.undo end if I beleive this will work.

I had a similar situation. Here is what I did. I added a Yes/No field (TAG) to the table itself. Instead of having the user "tag" the record, add a check box that they will actually mark as tagged. This way you will not have to go back and "tag" the records. Any processing you need to do...

Can't put my hand on the article now, but we found something on the MS knowledge base. Do a search on limiting users. It entailed opening the back-end database as ADO. I believe the code reads the .LDB file. I am currently testing the code now. One thing I noticed, a user is not considered...