Recent content by FireStrike

Thank you worked perfectly. Makes my code look quite a bit nicer.

Hello, I have a table called tbl2A. I want to open this table as long as there is some data in it. I have the code below that works very well. strSQL = "select * from tbl2A" Set rcd = CurrentDb.OpenRecordset(strSQL) rcd.MoveFirst If rcd.RecordCount > 0 Then...

This is a very complicated query. I have two tables, tblFromBob and tblGenCol. tblFromBob has the below columns. Sim is the PK. sim cat_no tblGenCol has the below columns. Sim and Generic_col is the PK. sim generic_col Identifier now what I need is the sim, cat_no, identifier_1...

Hello, Have you tried something like this? DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblFromExcel", strPath acImport tells it to import acSpreadsheetTypeExcel9 tell it what format your excel file is in "tblFromExcel" is the name of the table you want to put it in strPath...

Ok I figured this out. BTW I am using Access 2010. When you go to the design view you have to open up the properties. Once there you will see amung other two options, Unique Values, and Unique Records. You must set the Unique Records to Yes. Onmce this was done, it worked. When I looked at...

Yes both tables are local and my primary keys are below. My primary keys in tbl2R is newCC, newMfr, newItem. My Primary Keys in tblInventoryItems is country_code, sim_mfr_no, sim_item_no.

I rebuilt the query in the query designer, and came up with the same problem. Can you think of anything else. Everywhere I looked says this thing should be updatable.

Hey all, I am using Access 2010. I have two tables, tblInventoryItems, and tbl2R. tblInventoryItems is just a list of items we have in out inventory. It has three fields, country_code(int), sim_mfr_no(text) and sim_item_no. The tbl2R is a table with a number of replacements. tbl2R has the...

I have a question, and am not sure where to put it. I currently have an application that is currently an access app, but will need to be ported to vb.net. The problem I am having is that it creates an excel report. To format this report I simply created macro's in excel and pasted them into...

I believe you want to do something like the following. Set rs = CurrentDb.OpenRecordset("DivisionalLevelSpecific") Hope this helps

hmmm maybe I can help. I know there is a function to do this, but as I always forget the unction name, and have had problems with it pulling the proper row anyway, I use my own code to do similar. let's say that intRndNum is your random number. You can use code like the following to get the...

it looks like the line with the next statment is wrong. It should be as follows. next intCounter

text boxes don't use the .value, they use .text. If you want to set your variable to the text in a text box you will want to use. pass1=text21.text if you use this you will need to give text21 the focus, you can also use the following to get around that. pass1=text21 either should work.

awesome that worked. Thank you very much

I have a form that has a group of text boxes. The top one is a customer box and the rest is unimportant. What I need to do is to fill in the unimportant tesxt boxes on the change event of the customer box. To do this, I have to setfocus to each box individually update their information, and...