Search results for query: *

Hello! I have a form with a subform on it that looks at a query that takes a lot of time to load. I have the query to look for the values on a Text field that I have in my main form and then load the results in the subform. The subform loads when the main form starts up and the query starts to...

hello, I have a Tiff splitter that uses a DLL and adds a registry key to the computer. Is there a way to check for that registry key from the form in VB? If the registry key is not available, meaning it's not installed, then display a message. is that possible to do? thanks

Hello there, I have a form linked to tblMain. In the form I have to enter some data (acct number, buyers name, etc). I want the Save button to do a DLookUp on the ACCT field in the tblMain to see if the account has already been entered in the table. I would like to display a message that would...

Hello there, I have a form linked to tblMain. In the form I have to enter some data (acct number, buyers name, etc). I want the Save button to do a DLookUp on the ACCT field in the tblMain to see if the account has already been entered in the table. I would like to display a message that would...

Hello, I have a form that first it gets the name of the file and stores it in a variable. When I try to do the fso.MoveFile (<souce folder> & <name of the file>),<destination folder> it does not work. If I say "\*.*" it will move all files in the source folder but I only want to move the one in...

Hello, I have a batch file that runs with a button and after the batch file runs I have some more coding that does not work until the process in the batch file finishes. How can I insert a delay between the batch file command and the rest of the code behind the button? Thanks a lot. This is...

Hello, I have a report that runs from a form with currency values. How can I make fields in the report invisible when their value is 0? This is an invoice report, any other suggestions? thanks.

Hi all, I have a form for reports where you input the start date and end date in two fields for the reports. How can I automatically show the 1st day of the current month in a text field? Thanks

Hello, I need to make a report for a list of dealers displaying how many cars they have sold each month for certian year. How can I make it to show me only the month and year and how many cars per dealer? I know it's something like (Format[FieldName] and then how you want it formatted as thanks.

Hello, I have a query with another query inside it that can be ran by pressing a button from a switchboard. The first query is the following: SELECT [__acct and title].ACCT, [__acct and title].NEWSTOCK, [__acct and title].STATUS, TRDATA.NEWSTKLOT, TRDATA.LOT, TRDATA.BUYER, [__acct and...

Hello, my form has the following code to retrieve the user logged in to the computer and to diplay it in the form. =UserNameWindows() is in the default value of my username field. Some computers give me a runtime error and that the application has to be closed. I think it is the...

Hi, I have a login form that uses the following codes in the Login button: If Me.quserid.Value = "" Then MsgBox "Please enter a username to continue." Exit Sub Else If Me.qpwd.Value = "" Then MsgBox "Please enter a password to continue." Exit Sub End If End If If...

Hi, I have a login form that when you login it opens another form to do the entries. The login form remains open. How do I call the userid field from the login form to say in my main form "if userid.value = XXX then enable these buttons" ? Thanks! Any suggestions please comment

Hello, i have a batch to create a schedule tasks on the computer to then install an application. I also have a text/batch file with all the computers name. How do I tell the batch to create the schedule tasks to create it on all of the computers I have in the other file? thanks

Hello, is there a way to disable the printing of the forms? I have over 1500 records and sometimes by mistake users go to File/Print and print all records in the form view. How can I disable the option of printing the form view but leave enable the printing of reports? Thanks!

Hello, I have a report that in the query behind it I have a field for status. One of the status is "C". The Status field is not shown in the report. What I want is that in a text field in the report I put an IIF statement that will show an X when the status is "C" and black when there's any...

Hello, I have a form where I have some checkboxes that represent Received or Not Received data on a textfield and I would like to have that field with strikeline in the report when the checkbox is checked in the form. Any way to do this? Thanks

Hello, My form has 3 or 4 Find buttons created with the button wizard and I would like the Find/Search screen to close when the match is found. Is there a way to do this? Thanks.

I know I have asked this before. I need to link to forms. The specs are The main form's table has a AutoNumber as the ID field and has about 3500 records. Other form's table has an AutoNumber also as the ID field and is empty, it has no records (new table). When I use the wizard to open a form...

Hello, I created a table with all the dealers I need to run the report with. Then created a form and inserted a combo box with the dealers table and a button to run the report. How can I set my query to pull whatever dealer is selected in the combo box in the form? I have done this before with...