Search results

lets see if i can explain this correctly. If there is a better way please point that out to me also. Thanks. I have multiple forms that do just about the same thing. I want to clean up the database so I am going to use one form and switches to vary the data or displays if needed. the form...

Good day all, I have a sql2000 database on one network and i need data copied an access database which is on another network. the networks can't be connected together. This is what i have: I created a db that pulls the info out of sql and puts it in access. (this is done on the command line...

Not sure how to do a search on this one so here it is. I have a paytable that has years and dollar amounts to each year. Years 1-4 are consecutive and after 4 they increase by 2 up to year 26. Year 26 is the max amount you can get. ie. 2=20.00, 3=22.00, 4=26.00, 6 = 30.00, 8 = 35.60, 10=...

I am trying to run an update query and i get the following error: The parameter values are too large. The total length of all the values entered for the parameters cannot exceed 1,024 characters. The field is a memo field and it is just updating the other related records memo field also...

I am trying to add another record to a table. Pid and nsn are the keys. the table has 70 unique pid's. I need to add another nsn to each of the pid's. I tried the following code but no go: Set db = CurrentDb Set rst1 = db.OpenRecordset("tblHandReceipt") Set rst2 =...

I am getting an run time error 3061, too few parameters. expected 1 when i try to open the report. If i use this code: Set rsHR = Cdb.OpenRecordset("Select Count([HRID])as HR from qryrptflighthr WHERE PID = 'ae5698'" the report will open but if using the code below i get the error. The me!pid...

Is there a difference between me! and me.? I know if you use me. it will give you a list of the available items including any controls on the forms. I have been using me! Does it matter? Thanks,

Is this correct? microsoft DAO 3.6 object library and other references go with the database? I thought they were machine specific. thats why I have never coded using them. I though I would have to setup each machines access program that wanted to use the db with them. But I have a sample db...

I need to fill out a report with blank records that will fill up the last page of the report down to the page footer. Also, the first page of the report will have a 5 line page footer. all the other pages will have a 1 line footer. I can get the 5 line page footer to show on page 1 only and...

Hi, not sure looping is the correct word so i will try to explain what i am trying to do. i have a tbl and need to mark the records in groups of 12. the first group would be in group 1. The next group of 12 would be 2. and so on. the highest number is unknown as the data will grow. is...

I have a report that has 20 columns but they will not fit on the same page. I don't want them to go across and down or down and across using the setting on page setup. I need to display all that can fit on one page then continue the other ones on a new page. thanks for the help