Search results for query: *

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...

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...

have a button on a form that I want the user to be able to refresh the data, but I can not get it to work. This is the code I am using. When I click the button nothing happens. What is the code that I should be using? Me.RePaint or Me.Refresh do not work

I have two combo list fields (unbound) on the top of the page. I have a query that in the fields to look up they say [forms].[fQA_Raw_Materials].[Vendor] and .[Heat] The problem I have is how do I deal with the combo lists when one is null and the other is selected? Also, when both of the...

I have a button on a form that I want the user to be able to refresh the data, but I can not get it to work. This is the code I am using. When I click the button nothing happens. What is the code that I should be using? DoCmd.RunCommand acCmdRefresh

I have a file DSN that seems to lose it's connection with a linked table in SQL. I do not connect with NT authentication, but instead with the SQL authentication. I type the PWD in but doesn't get saved with the DSN (looked in Notepad. So added the line PWD='MYPWD'. Still gives me the same...

I have a table on SQL that stores the environ("username") along with his or hers user rights. 1 = yes and 0 = no for the columns that represent an area in the database. What would be the easiest way to implement in the db block or allow users?

I need to create my Access database so when the mdb is created the user has no ability to shift - Enter and view the tables and/or queries. I know I can modify the start up tool and create an mde. But even then people are able to view everything. What could I do?

How can I set up a macro to copy files from a network drive to a local folder on their hard drive? I would like to do this without seeing the DOS window (cmd).

I would like to do an ON OPEN for a form and have it INSERT INTO a table the operating system that the user is current on. Is there a way to do this?

I have a subroutine that I have ON OPEN for a few of my forms. I would like to take that subroutine and make it so that for all of my forms that open to do this subroutine. How do I go about doing this??

I have an Append query that currently captures data when a user OPENS a form or a report. The name of the user (USER: Environ("username")), the timestamp (DATE: Now()), and the Host (HOST: Environ("COMPUTERNAME")) are what I am currently capturing. I am looking to add one more field (Task) and...

I am not a programmer, but I need to learn how to implement activex's in SQL Report Services and SQL. I have Visual Studios to work with. Can someone guide me to learning Activex's quickly and profficiently? thanks... email me or reply to this post. greg_pyles@lincolnelectric.com