Search results

Hello, I'm trying to use DAO to update within the table properties, the description. This is what I have so far. I haven't tried to run any of this code. Function ModifyTablePropertyDescription(strArchiveTable As String, strTableDescription As String) Dim db As DAO.Database Dim tdf As...

If I link the file, it works.

Thanks for the info. Were you able to test the import on your machine?

This is a weird problem. Attached is an excel spreadsheet that when you use the default import process is Access 2010, it produces an error file which states truncated record. Within the spreadsheet, this error happens with column "CL." If you remove all the columns before "CL" then save the...

The customer wants to use the keyboard.

Here is a working DB. I only want the tab key to be able to move to the next field, and I need to make sure the field has data within it.

In Access 2003, I can't get the form to open properly. I can't figure out which reference I'm missing. Maybe you'll be able to tell. When the form opens, all that is visible are the control buttons: edit record, update box, add box, and close.

ok. Removed the double quotes. That had no affect on my original problem.

No, it advances to the next field.

Here is my code within the keydown event in a textbox named GUTS If KeyCode = vbKeyReturn Then KeyCode = 0 ElseIf KeyCode = "9" Then If IsNull(Me.GUTS) Then MsgBox "You must enter something within this field" KeyCode = 0 End If End If...

It what the customer desires. I explained the pitfalls, but I need to try and deliver what they've asked. If I get it working like they've asked, they probably won't like it. At least it's a good learning experience for me.

A requirement of my current db is that when the user reaches the last text box on the form, they need to press the enter key. How do I code it so after they've entered some data, if they press any key other than the return key, it stops all the other events within this text box and it resets the...

Thanks lagbolt and Bob. I didn't see lagbolt's reply until Bob mentioned it. that's exactly what I needed!!

I understand what you've suggested, but that doesn't solve my question.Is their anyway to use the values that are within my recordset, and set those options to true. Using this example: buttons are named, option1, option2, option3...option10 my recordset returns: option3, option5, option7...

On a form I have 10 option buttons. Named option1, option2, option3.. If I create a recordset which the contains the option buttons I would like set to true, what is the sytax for setting that option button to true? An example, if my recordset returns the following: option3 option7 option9...

That helps alot. Thanks

Can you provide a little more detail to your solution. Thanks!!

Is their any way to determine if the user pressed the "tab" key or the "enter" key? I'd like to preform different events after determining which keystroke the user performed.

Unfortunately, my charge factor is a judgement call based on information I view on a web site. I have a quote form that I review the data that has been imported, then enter the charge factor. It then creates a contract, and emails it to the email address within the record. Your piece, was the...

It works perfectly. What I did was once I import the record, I parse out the 2 zip codes, then place them within your variables zip1 & zip2. I use the distance to calculate a charge for potential customers. This saves me about 30 seconds per import record. Thanks again!!