Recent content by Gunilla

Thank you guys, I just forgot about the make a table querry. Sometimes it's good to have somone to point out the obvious. Bye for now from a rainy Sacramento, CA:D

I am using Access 2003 and I would like to create a table from a querry. I usually go via Excel but sometimes there are too many records. The information is downloaded via ODBC and I don't need all the information only a fraction. Is it possible to do this? Thanks for your help :confused:

I have created a form where I have a button that runs a code to transfer information to a text file. When there are records that should be transferred the batch number, that is the date in Now format, is entered. This is where I used your suggestion v_Batch = Format(Now, "mm/dd/yyyy hh:nn:ss")...

Thank you, but it didn't work. This is how it shows 4/20/2010 4:21:18 PM and I have to have two digits for month and day. Do you think it is a bug or is it just Access telling me "I do it my way", Gunilla

Hi you all Is there a way to code now() in VBA. To be according to the remote database I need it to be in the format dd/mm/yyyy hh:mm:ss (03/03/2010 09:09:09 AM) I can get the format working in a query but the problem is that my code is looking for a special field with the now() value and that...

Hi this is a code I use to export data from Excel to Accesss. I am using Office 2003. Sub FromExcelToAccess() ' exports data from the active worksheet to a table in an Access database Dim db As String Dim cnt As ADODB.Connection Dim rs As ADODB.Recordset Dim r As Long Dim stTable As String 'in...

Thank you guys, now I have something to work on, I would never have been able to find this information myself. I also thank you for showing me the difference between toolbar and menubar. It really isn't easy when you are not familiar with the terminology. Thank you. :) Gunilla

How do I make sure that all menu bars except my customized bar is closed when a form or report is opened. :confused: Gunilla

Hi again I have created new menu bars. But I am not happy with the result. The problem is that it shows up like a menu bar with icons not with text. I think I just have to go with it. It looks so much more professional when you have the toolbar in text, I think. It's a pitty if they took...

Thank you, I knew it was a long time ago I used the menubar macro. But does this mean I cannot change the default toolbar. I mean I want the File show but the only options should be Close and Open, In the Edit menu only export, import and find should be enabled. The rest of the option in the...

How do I create a customized menubar? I know that I "once upon a time" used macros to customize menubar to use with specified forms and reports. Does anyone have a clue on how to do it or where I can get the information? ;) Gunilla

Thank you I knew I could count on the forum's Gurus. Happy Easter

Hi I have a form that I want to use as an input device for a query request. The form has 4 fields. cboUser (A combobox with the users name), cboProv (A combobox populated with names from a table) txtFrom (a textbox where the from-date is entered) txtTo (a textbox where the to-date is entered)...

I am exporting to a text-file that will be imported to another database and the field property in that database is string and 7 characters.

No this does not work. I don't understand why. I just have to fill up with 0's from the left. I am just working with the table could that be the problem.