Search results

the code does return one record, the pid of a person. but there are several items associated with each pid. Set rsHR = Cdb.OpenRecordset("Select Count([HRID])as HR from qryrptflighthr WHERE PID = '" & Me!PID & "' ORDER BY nsn") give me and 'excute a query that does not include the...

I am trying to sort on nsn now and the following code: Set rsHR = Cdb.OpenRecordset("Select Count([HRID])as HR from qryrptflighthr WHERE PID = '" & Me!PID & "'" & ORDER BY nsn) putting the sort in the qryrptflighthr doesn't sort it. Thanks

that did it! I can hit myself for not seeing that, I have used that code before, '" & ... & "'" But I couldn't think of it at all. Thank you very much pbaldy!

I did this: Set rsHR = Cdb.OpenRecordset("Select Count([HRID])as HR from qryrptflighthr WHERE PID = 'Me!PID'") report opens but no data in it. The report it self has a record source of qryrptflighthr. should i do that? I tryed taking the record source off of the report and changing the...

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,

Thanks for the info! Should help some now.

How would you know which common controls require the files? Can it be assumed that if you didn't add any special files to your machine, it should work on pc2, and if pc2 is assumed to have a standard load of office. I don't want to use anything extra that would require administrative rights on...

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...

okay no bites, is there a way to assign items to a page footer? say if its page 1 use this footer or subform else use this footer or subform. thanks

1) http://support.microsoft.com/?kbid=207624 has some code 2) this is what i use, got it from a forum not sure which one though. make a grouping for the field you want. and on the on print event of the grouping put this code in: Private Sub GroupHeader0_Print(Cancel As Integer, PrintCount As...

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...

it looks like you need to link the spots all table to the shifts subform table. Then on the combo box put critiera on the spot field so that it is checking for a null or blank spot. That should list only the spots that are open. 67

PERFECT!!!! it does what I was looking for. There won't be a large # of records that need to be updated. So running the code on the close of the form if a delete record has happened will not be a big system slow down. Once again thanks for the help! Is there a way to have them be listed...

Here is a sampledb, the forms and tables associated to the problem. Thanks

the program was first started in access 2000 and i haven't converted it to 2003. I want access 2000 users to be able to use it.

Yes, rptlevel needs to be updated. I give them a rptlevel at the time i add them to the department (doing that now.) Now if i remove someone from the department, if that person was in rptlevel 1 and there are 3 rptlevels, rptlevel 1 has only 11 people and i need to fill that 12th slot. I...

I would use an update query not an append. UPDATE WeldingSpecification SET Substitute1 = Null, Subsitute1 = Null; just keep adding the fields you need

changed it to: SELECT accountletter, DCount("RPTLEVEL","tbluser","RPTLEVEL=" & [RPTLEVEL]) AS Increment, Int([Increment]/12.01)+1 AS groupnum FROM tbluser; no errors but it list all the accountletters, (just need the one that I am on.) the increment #'s are 30, 9, 7, 3 and the groupnum are 1...

Sorry I don't use SQL code alot. This is what I did: SELECT accountletter, DCount("accountletter","tbluser","[accountletter]=forms!frmsubaccounts!accountletter") AS Increment, Int([Increment]/12.01)+1 AS rptlevel FROM tbluser; the keys in this tbl are accountletter and lname. the rptlevel is...