Search results

Learn how to use the DSum() function.

The 2003 runtime is not free, it comes with the developer extensions package which is not free and I doubt you can still buy it new from Microsoft since it is so old. The access 2007 and newer runtime downloads are free. Your friend should be able to convert your database to the Access 2010...

If you just want to display your own Record X of Y status instead of using the built-in version then check out my old Record X of Y sample.

Sorry I do not have the time to decipher your query. Open up the query you have created in the design view and you will see the problem. Fix the query then go back to the code you are using to create the query and adjust as neccessary to fix your problem.

There is a problem with your query that you are building so you need to fix that first. Your first error is fixed by replacing DoCmd.OpenQuery ("MyQuery") with DoCmd.OpenQuery "MyQuery". Then you will get another error because of the problem with the SQL you are building.

Try this in your forms on open event... Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open If CurrentUser = "Userlevel2" Then Me.AllowAdditions = True Me.AllowDeletions = False Me.AllowEdits = False ElseIf CurrentUser = "Userlevel3" Then...

The Form_Current event fires every time you move to another record. You should put your code in the Form_Open event to only fire the first time the form is opened. Check these out for more info... Open Event [Access 2003 VBA Language Reference] Current Event [Access 2003 VBA Language Reference]

Withing each subform, set the record selector, navigation button and scroll bar properties to No. I would also hide the record selector in the main form.

Please use the code tags which makes it easier to read your code. This should give you an idea on how to do it... Option Compare Database Option Explicit Dim bCounter As Byte bCounter = bCounter + 1 If UCase$(Me.tbPassword.Value) <> UCase$(gcPassword) Then If bCounter < 3 Then...

You should try to avoid using On Error Resume Next. There should be an error number if there is a runtime error. Change your error message from MsgBox Err.description to Exit_cmdCreateRelationships_Click: Exit Sub Err_cmdCreateRelationships_Click: MsgBox Err.number & " - " &...

You can use the format function to display the date however you want it. format([YourDate],"yyyy/mm/dd") You can also change the users regional date to the format you want.

Have you tried reinstalling Office 2007 since you installed Windows 7?

1) Search the forum for there are threads discussing how to create a shortcut. I believe that I have posted the solution in this forum somewhere. 2) I did this once before. I would have the front end check the back end for a version number. If it did not agree, the front end would close its...

The runtime installation should have installed the MSACCESS.EXE file on their computer. Do a file search and see where the install placed the MSACCESS.EXE file. Then adjust your shortcut properties for the correct location.

For Access 2003, you need to adjust the users computers settings for macros and the sandbox. >>> Frequently asked questions about Access 2003 security warnings Read this old thread on how I alter a users registry to disable the Access 2003 Macro Warnings and SandBox mode...

Have you tried creating a report to print with your chart instead of trying to print a form?

Bob's method is best because it also alerts the user. Sometimes a user will alter a field without realizing it and would save the unintended change if there wasn't a trap to catch a dirty record before the user moves off the current record or closes the form. I still use a version of my old A...

I use this to hide/unhide the ribbon and navigation pane... DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.ShowToolbar "Ribbon", acToolbarYes DoCmd.RunCommand acCmdWindowHide DoCmd.SelectObject acTable, , True

I never liked the restrictions of the switchboard so I make everything from scratch in my forms. I give my users the choice to either preview or print the report when they select the report form a combo box listings the available reports from that form. If MsgBox("Do you want print or...

I agree but sometimes it is easier to print the current record in a form (for auditing purposes) than having to recreate a report of the same information and it would be a lot of unnecessary work to get a report to look like a form. This is what I use to print the current record in the opened...