Search results

Found My Own Answer I Must be sure that the field in my Excel File is set to Number... no Decimals. Sorry for this post, but looking up topics here was a lesson about this Forum! Good job Guys and Gals!!! :D :D :D :D :D :D :D :D

Hi, I'm running an Append Query from an Excel <linked> file to a table in access. From what I can tell, the first filed is overflowing with a linked filed numeric of 'Double'. You can't change linked table fields. However when I first link the Excel file, the Append works... :D only when I...

ysfpsu Set up your form with the corresponding table. For those fields that remain constant, select properties {data} tab and set the InPut Mask and Default Values for each of your fields. Leave the USER ID blank so you can fill that in. This will allow you to type over any of your...

Ba-Da-Bing! Thanks so very much... I can now also track if anyone messed up one of my queries too!! :D

I update, import and export tables, problem is I need a way to track what I have done or allow someone to pick up where I left off. Is there a way for MS Access to return the Create or Modified Date and time stamp of any table? :eek:

We thank you for your support!

OK... here is some sample data from the original spreadsheet. The account numbers are toward the right.

So this step can not be done in the 'Normalize' wizard? If I run an 'Append' query for each account, what am I appending? Is i the account value, or a new table with a new field called account? Thanks for your quick reply! :)

Hi, I think I know my way around a database, but my new employer has me doing kart-wheels. There is an Excel sheet of values which I have imported to Access tables, the table contains ledger values on it and the account numbers are in the fields as column headers. I want to reflect those field...