Search results

I am writing some Excel VBA to retrive a value from an Access Database called SSI20031.mdb. In a nutshell I want the code to look at the value in Sheet1 cell F55 of the excel spreadsheet and then find the record that has this value in the "ID" field of query called "Code Generator" of the...

I have a table that has the following data in it "Deal Number" "Profile 1 Amount" "Profile 1 Date" "Profile 2 Amount" "Profile 2 Date" all the way through to "Profile 10 Amount" "Profile 10 Date" The profile date could be anything from today to a date in 10 years in time and can be...

I am trying to add the number of months as referenced in my "profile months" field (in my FERC DATABASE2 table) to the date in my Tender Expiry field of the same table I have seen the DateAdd function where DateAdd(Interval,Number,Field) This works fine if I put DateAdd("m",1,],[FERC...

I have a report that is grouped by a field called SiteName. When I run the report I get a front page with some summary statistics against each site and then a second page which details indivudual line details from my query. Currently when I run the report all the sites come out together and I...

I have created a simple query that produces data in this format: Year Amount 2009 5 2010 10 2010 15 etc. When I run the Chart wizard the chart does not fit the page properley and when I try to play round with the design I seem to lose part of the chart or it starts to...

I am trying to add a hyper link to a report in access. I need the hyper link to change depending on the name of the business unit that the report is run for. The Report is based on a query (Business Unit Select) which prompts for a Business Unit name via a Form combo box (combo0). So the...

I have a table in my database called CPARTY that lists all the business units in my company. This table also has a field called short code. I have a form that I want to use to enter data into a table called BU. The form has a field called BU that pulls in the complete list of business Units...

I have two tables that are linked by a common field called 'reference'. i am running a query and want the query to post a text of "EXCHANGE OV CHANGE" against each record where a field called "ORIG Value", present in both tables, differs by reference number Expr2: IIf([Bank...

I am using an append query to write records to a master table that I have created. I then want to create a query to clear out all the records from this master table. I have created the usual delete query - but when I run it it is saying that it going to delete considerably more records than...

I have added a button onto my form to simply open a table I have called Internal SSI - this is the code I have added to the button - but the code doesn't work! - Any ideas? it must be to do with the DoCmd.OpenTbl bit - but what should enter in its place? Private Sub Command4_Click() On Error...