Search results

By using "int", Integer. The "int" is reporting the integer, 62. No rounding or other calculations. A "real" or "double" would round the value to some defined decimal place, thus, reporting the entire value.

Please explain how this works? Can some one help explain how this works? If that some one has time to add notes to the code. ;) It works as shown, I'm just not sure how or what happens to the Excel object being created or used. Hopefully, if I understand it better I may be able to modify this...

Thank you!

You could have a vba module check each textbox for "", if it is "" (null) then hide the textbox.

Can I use an excel worksheet (workbook with 4 sheets) for my access reports instead of redesigning them in access? It would be a time saver for me if I can, I already have modules within excel to populate the sheets with my data.

Solved: Learned to establish foriegn key links in code Example: With myrecset3 .AddNew !txtRev = myrev !fkPartID = holdpartpk 'Foriegn Key link holdpartrevpk = !pkPartRevID...

I have a couple questions after importing multiple data sets. 1. tblPartRev pops up a dialog box to select tables "to insert subdata sheet"? (After clicking on the "+" sign to expand the selection). I am not sure what to do with this. 2. Can I reset the primary keys on all tables back to "0"...

I see what you are saying. Excuse me if I mesrepresented what I needed. I think I confused part and pieces based on your tables. A job can have many pieces (each unique) and for each piece there is a unique serial number tied to a single part number.

You are correct. All bubbles can have multiple values. In this case, like I do in Excel, I create a range of the values, "Min-Max". Example: .0001-.0055 for bubble 100 (just numbers pulled out of thin air). A Job number can have multiple parts (same part number), multiple serial numbers (same...

This is excellent, there are some key coded areas I was failing to figure out. I havent read so much since the eleventyth grade. :lol:

I just stumbled onto that from another post. http://www.btabdevelopment.com/main/QuickTutorials/HowtocreateanImportSpecification/tabid/98/Default.aspx After creating the spec, it works well.

The code below imports my text file, but it ignores most spaces leaving me a useless table of concatenated data. The text file is space delimited. DoCmd.TransferText acImportDelim, , strTable, strInputFileName, False How can I import a text file space delimited? I have no problem importing a...

tblPartRev: fkPartID; Required = No doesnt have an option for "Zero length"? txtRev; Zero length = Yes

PK is autonumber fk is Number (Long integer) txt is text For null values, if you mean "not allow zero values", tblPartRev is set to "Yes" Required is set to "No"

The snippet of code below should add a new line to the table "tblPartRev" but it doesnt. I think it has to do with a foriegn key in that table. The table: tblPartRev pkPartRevID fkPartID txtRev myrecset1.Open "tblPartRev", , adOpenDynamic, adLockOptimistic...

Excel 2000, 2003 has a limit of 65536 rows by 256 columns. Excel 2007 over 1 million rows by 16384 columns

Thanks ;) I would have picked up on that eventually, Im quick like that. :D

HA! I had a bad table name.

Wierd. I re-pasted the code indented and the forum changes it to unindented.

Thank you for all the help you provided! Regards Rick