Search results

DoCmd.RunCommand acCmdAppMinimize doesn't work at all. DoCmd.Minimize minimizes the form and leaves Ribbon and the icons exposed. However, I am using Peters Software ShrinkerStretcher. Could that be causing a problem?

I have looked everywhere and cannot find the answer. I need to minimize the MS Access 2010 application. DoCmd.Minimize and DoCmd.RunCommand accmdappMinimize does not work. It closes the current form, but not the app. I need the app to minimize to an icon on the Taskbar. Can you help? Thank you.

frmMain has a subform, frmMainSub. I change the sourceobject of frmMainSub for some procedures with this: Forms!frmMain!frmMainSub.SourceObject = "frmMainSubSub" frmMainSubSub can be any of several forms. On one form I have buttons to see different views of the data. The default view...

I know this is probably already in the forum but it is getting pretty big and I can't find the answer. I have this: frmMain frmMainSub frmMainSubSub recordsource = query1 How do I change query1 to query2? I hope this makes sense. Thank you.

That worked. Thanks.

I have a form with a subform on it. The subform has subforms. I need to set the focus on a control on one of the subforms. Here is what I am using. START OF CODE Forms!frmMain!frmMainSub.Form.frmContactLog.SetFocus Forms!frmMain!frmMainSub.Form.frmContactLog.ContactMethod.SetFocus END OF CODE...

You say you can't update a linked Excel table? If that is true, then I will import it. Also, the that I was speaking of was the @ symbol. Thanks.

I have a linked Excel table in Access. I ran a query against it and it said it was not updateable. I checked the table and found that in design view, the table is a text field and in the Format box is an @ symbol. I can't get rid of it. I tried going to the Excel file and reset the format of the...

I will have about 3,000 sheets. Everything I have seen thus far seems to be for one sheet at a time.

I don't have to scan into Access. I can scan into Excel, or ?, and import to Access. Does that open up any thinking out there?

I don't have any scanned documents. I am looking for ways to scan and get the data.

Once a year we have a conference that has about 400 people attend. These people will participate in several classes, randomly, over a four day period. Each class hands out an evaluation form. This form has six categories and asks you to rate each from 1 to 5. This is done with a grid on the form...

Once a year we have a conference that has about 400 people attend. These people will participate in several classes, randomly, over a four day period. Each class hands out an evaluation form. This form has six categories and asks you to rate each from 1 to 5. This is done with a grid on the form...

I am not sure how to use that. Can you elaborate a little? Thank you.

I was moved from a project for a while and then brought back to it. I had two programs that were being used in this project. I had a process set up that used something similar to the following line of code: Shell "WScript " & """C:\MyFolder\MyFile.vbs""" This would run a script that would...

How do I save the data in that field? The field is: Forms!frmRegistration.frmRegistrationSub.Form.Registered

I have a form (frmRegistration) and a subform (frmRegistrationSub). On the subform is a field that receives a letter when a button is clicked. This field gets counted. So, after clicking the button, I need to update the count. I do this with the Docmd.RunSQL code. START OF CODE...

Thanks for your help.

I have table tblLog set up to track logging on and off. All I am tracking is the date and time the user logs on and logs off. That's pretty simple to do. When logging on it appends the userid, date, and time to tblLog. When logging off, it updates the logoff date and time for the matching...

This does not work. ="The scores below are based on the number of total evaluations (" & Format (Sum([TitleIDCt]), "#,###"& ")."