Search results for query: *

When I scan a barcode to a text box i want it to move to the next tab stop. The scanner is set to append a Carriage Return/Line Feed at the end of the scan. I know the scanner is set up right because I can scan into a spreadsheet and the cursor advances to the next field. Scan lengths can be...

I have a sql statement that returns 1 field. I need to put that field into a variable. I know I can open a recordset to get the value. Thie sql statement runs several times during the program execution. Is there a way to directly put the result of the sql statement into a variable without...

I have check box that should hide a field or display a field depending on its status. I placed in the after update procedure. If it starts out as false and changes to true then it displays the fields but once changed to True it always shows True. Here is the code. If Me!ContractChairs.Visible...

I have one combo box that is dependent on a second box. I have read the articles on how to do this I am curious why referring to the column in a query doesn't work. This works in a RowSource on a Combo Box SELECT tbl_IP_Profile.AssemblyCode, tbl_IP_Profile.LineID FROM tbl_IP_Profile WHERE...

Yes. I found I have to use chdrive command on the windows7. XP will change both drive and directory when using the chdir command. Thanks for your help Razor1

The CHDir command does not seem to work in Windows 7(64 Bit). When I run the code on an XP workstation it places the file in the proper location. When I run the code on Windows 7 (64 Bit) in places the file in the documents folder. I have also hard coded the the change directory and it has no...

Many thanks. Have a star. Razor1

I am creating a view that work properly except that the field size for the item no is a varchar, 8000. The field should only be 50 characters. How do I make the ItemNo (varchar, 50)? When I link the table to Access it converts the field to a memo because of the size of the field. Here is the...

I create field names in a table based on an entry form, the field names can change every time the program is run. I need to place data in a field whos name changes everytime the program is run. Basically what I want to do is assign a variable for a field name and then write to that field...

That worked. Thanks Razor1

I have a form that is open and when the input on that form is completed I open another form with the timer value set to close in 5 sec. I then want to set the original the focus to a field. The focus is not set to any field when I close thethe original. Here is the process I am using: 'Open...

I am emailing spreadsheets generated by the transfer method in access 2003 to iphones and the spreadsheet will not open on the iphone. The iPhones have Docs to Go installed. If The spreadsheet is opened on a desktop and saved then emailed to the iphone then the spreadsheet will open. The...

I am using Access 2003. When using SendObject to email a spreadsheet the spreadsheet is saved in excel 95 format and the new smart phones using DocumentToGo can not read the format. How doI have the SendObject save the spreadsheet in 98-2003 format? Razor1

I create a directory on the C: drive and can not delete it. The code: strFolder = "c:\Test" mkdir strFolder Load files into directory Process Files rmdir strFolder I have also tried strFolder = "c:\Test" mkdir strFolder Load files into directory Process Files Kill strFolder & "\*.*"...

I don'r write a lot of sql statements so I would appreciate help with this. I need to update a colunm with the current value plus and .csv to the end of the contents in the column. Example: ARBatchFileName = R01234 (Currently) After update it should be: ARBatchName = R01234.csv Here is the...

I get an invalid reference on this line If lbo.ItemsSelected.Count = 0 Then Any ideas? Function IsSelectedVar(strFormName As String, _ strListBoxName As String, _ varValue As Variant) _ As Boolean On Error GoTo PROC_ERR Dim lbo As ListBox Dim item As Variant If...

I should have mentioned I have a single table with the 2 fields, model and color. List box 2 should update when list box 1 changes. Thanks again for any help provided. Razor1

I have 2 multiselect boxes.Box 1 contains models box 2 contains colors related to specfic models. I want to show only the colors for the specfic models in box 2. Box 2 is also a multiselect box. Example: Model Color 1 Red 1 White 1 Blue 2 Geeen 2 Yellow 2...

I have a form with 8 fields that I need to compare to see if there is a duplicate entry in any of the fields after entry in each field. I am not sure on the best way to approach this problem. I know I can put code in each field to check the other fields but I was looking for a way to do it...

Thanks. I will have a much better weekend. You have a good weekend also. Razor1