Search results

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

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

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.

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

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

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

is it possible to have the source of a text box set up as an SQL expression? What i want to do is when the records from a particular table are displayed on a form, it goes out and grabs a field from another table which is related to it. so the sql would be something like SELECT [Phone Number]...

Is there anyway to rename a table and then have al the queries/reports/forms automatically change to reflect the renaming?

I have a simple form which opens a report based on a query. It keeps asking me for 'Tendor No' even though it is IN the query and i am just specifing it in my docmd.openreport call. I tried redoing the form, the report. and the query, but no matter what it prompts me for the value. I have no...

I am trying to use either cancel = true or docmd.cancelevent to stop the printing of a report when there is no data however, it comes up with the error: 2501 The OpenReport action was canceled. Is there anyway around this inane error? i tried docmd.setwarnings = false but it still came up

i have a form which brings up a report using docmd.openreport and the where clause i have a field in my report (which is based on a query) called [Tendor No], when i click the button on my form it uses a clause of [Tendor No] = "something" but it keeps prompting me for tendor no it is driving...

is it possible to make an update query where the "update to" parameter could be specified by the user? that is, i want to update the field to a non-static string

I am using docmd.cancelevent in the on no data event in my report but for some (stupid) reason access is telling me 'The OpenReport action was cancelled.' Is there anyway around this ridiculous error message?

I have a report which when used on an empty data set gives me this error: 'You entered an expression that has no value.' It is trying to evaluate: If Me.Wdate < Date Or Me.Idate < Date Or Me.Ndate < Date Then So i assume access is stupid enough to error because there is no data instead of...

The expression being evaluated is if (wdate <> NULL AND wdate < date) then ... end if now the error i am getting is "You entered an expression that has no value (2427) So what i am wondering is is it evaluating the left hand side of the AND expression even though it is seeing that wdate is...

I want to make it so that for each record it does a test and if it passes this test it will change the font of a text box one would think the onformat event crap would be where i would look but i dont seem to have any luck making it work any ideas?

I am trying to do a simple compare on my report in a text box. I have the following code in my control source but it is returning #ERROR on my report: =Iif([WC DATE] < date(), "Date is in the past", "Yeehaw") do i need #'s or something?

I have a report made which is all laid out how i wish it to be. But i want to change the query of the report to something new based on a users input in a form. I know how to create the new query, but i do not know how to apply that new query to my old report. Is this possible?