Recent content by chippyles

I am using IE because I am using a program called SiteKiosk which blocks people from the operating system. So startups in window do not work. I have to use IE which is the core of Site Kiosk. It would be the second window. And what do I do about disabling the filedownload warning?

I have a computer that loads Internet Explorer anytime the computer reboots or powers up. the below code is also attached to the html so I can start up an application automatically. Two things happen that I do not like. A seperate IE window pops up and I get a pop up msg about file...

I would like to create a date picker for an unbound text field called Start and one for End. I would like to have the calendar for Start (Calendar1) and the calendar for End (calendar2) to be only visible when the cursor is in the text box. then I want the user to pick the date and the date...

I would like to put a BETWEEN START DATE AND END DATE in the criteria of a query I have. The start and end will be from an unbound form, but the person does not have to enter the start or end date all the time. This code works only when there is data in the combo box. Between...

I would like to put a BETWEEN START DATE AND END DATE in the criteria of a query I have. The start and end will be from an unbound form, but the person does not have to enter the start or end date all the time. Between (Like nz([forms].[fQA_Raw_Materials].[START],"*")) And (Like...

I have 6 combo boxes at the top of the form and people can come in and click from a list what they want to see. They click 'go' and the results are displayed at the bottom of the page. I would like to create a button that clears the combo results. What would be the VBA for clearing the 6...

The only problem is the Screen has to be active. The screen is 99% of the time closed. When I open it I get a debug error saying the screen needs to be active.

This is the code I used as a function I got an error stating. Compile Error: Invalid use of Me keyword What now?? Public Function FormProcess() DoCmd.SetWarnings False DoCmd.RunSQL " INSERT INTO LOG_REPORT ( [DATE], [USER], HOST ,TASK, DB )" & _ "SELECT now() AS [DATE], environ('username')...

I did what you asked and I am now getting an error. Compile Error: Expected variable or procedure, not module

I have an On Open event procedure in VBA that I would like to make it global to every form or report open. How can I go about doing this?

This SQL command in VBA computes the user name, host name, time stamp and the task as the Form or Report name. Answer this riddle... Form or Report is to Me.Name as Name of DB is to ??? I need to capture the name of the Db the person is using so I can differentiate the forms and...

I have 6 combo boxes on a form that determine a query. Each of the fields in the query have a criteria (Like nz([forms].[tQA_Raw_Materials].[SID],"*"). I was advise to use this criteria because it would still return a value if the combo boxes were null. The only problem I am having now is...

forget it now. Everyone kept telling me to do Me.Requery I just put in DoCmd.Requery and it works now. Thanks!!

I just did the wizard and it seems to be refreshing the Form Header and not the Detail section. If I press Shift F9, it works. the button however does not. How can I create a command that similates the shift F9 or does the Me.Requery on the detail from the form header?

Me.Requery does not work.