Search results

Yeah thats what i meant, and that worked. Thanks.

I have a page control on my form. i can add other controls onto the pages so long as they are new ones. But how can i place the controls already on my form onto the pages?

I have created a report which groups by year and then by location as follows: YEAR1 .................LOCATION1 ...................................................DATA .................LOCATION2 ...................................................DATA .................LOCATION3...

hmm maybe this is even a question of normalization. i may be doing this wrong. i have a table with all of the people's information and i want to have another table which says which courses they have taken i have firstname, lastname, and ID number in both tables am i doing this right? Should...

i have two tables that are related by three fields. is it possible to populate my new table with all the data in those three fields from my other table? i tried an update query using a select statement as the update to but i didnt really know what i was doing and it didnt work out any help...

i just re-wrote my query by hand to come up with the following which put me a half step closer to where i want to be: SELECT RIMcontracts.[Tendor No], contractors.[Phone Number], RIMcontracts.[Project No], RIMcontracts.[WCB Valid Date], RIMcontracts.[Insurance Valid Date], RIMcontracts.[NSCSA...

I guess i could just have my query select only the rim contracts us ing a query (which does not cut off the first 3 characters) and then have a subreport using another query that selects only the WIN contracts underneath it but it seems like i should be able to do it with a union query

here is my union query: SELECT RIMcontracts.[tno], contractors.[Contractor Name], contractors.[Phone Number], RIMcontracts.[Project No], RIMcontracts.[wdate], RIMcontracts.[idate], RIMcontracts.[ndate] FROM contractors INNER JOIN RIMcontracts ON contractors.[Contractor Name] =...

can i make an update query that will change a certain field so that it is a string and then the rest of what the old field was? so say here's my table Field1 -------- 45 46 47 48 after the update it would look like: Field1 -------- XXX45 XXX46 XXX47 XXX48 I'm sure this shouldnt be too hard.

igor, what i ended up doing was creating a new row in my table, copied all the info from the 'tendor no' field into it, deleted 'tendor no' and then renamed my new field 'tendor no' that made it work. didnt even have to mess with the query once i did that. weird huh?

i have a simple select query which is the basis for a report... when i go to open the report, i wish to specify a field (project no)in the where clause that is not a field in the query, but is in the underlying tables of the query the reason why i cant add the field to the query is because if...

jtvcs, is it possible for my filter to go through to my subreport?

sounds great ill give it a shot thanks alot.

I have a report which is laid out as follows: it breaks each service down by location and then says the service name, the quantity, and the cost: LOCATION SERVICE QUANTITY COST Sydney PATCH 55 12,000...

each of those is a field, not a table name it actually is smart enough to know what table the fields are coming from, surprisingly as a side note i had it setup as TABLE.FIELD before what you see above and it changed absolutely nothing

its like it doesnt see 'Tendor No' in my table it doesnt have any beefs with any other fields, just this one is there anything i can do? I tried renaming the fields (which would create a HEAP of other problems, but even that didnt work) it just seems to hate the field (or me) god help me please

here is my syntactically immaculate query: SELECT [Contractor Name],[Tendor No],[Project No],[WCB Valid Date],[Insurance Valid Date],[NSCSA Valid Date] FROM [WINcontracts] UNION SELECT [Contractor Name],[Tendor No],[Project No],[WCB Valid Date],[Insurance Valid Date],[NSCSA Valid Date] FROM...

if you really want to make a crappy DOS batch file its simple: batchbat: @echo off TYPE FILE1 >>NEWFILE TYPE FILE2 >>NEWFILE TYPE FILE3 >>NEWFILE etc etc

hmm i dont quite follow but i used Forms!blah!blah instead of me.blah and it worked What did you mean by adding it to the combo though?

some code can you guys tell me what's wrong with this, it is what i have in the control source for me phone number text box: =DLookUp("[Phone Number]","contractors","[Contractor Name] = '" & [me].[combo27] & "'")