Search results

Hi Apologies if this has been covered before, but a quick search didn’t bring up any solutions…. I have a customer table with name/address etc, together with a url field. Currently this is set to a datatype of Hyperlink. I then have a customer form that displays the underlying records, and...

Hi I have a form with two checkboxes; depending on whether one/both/none are ticked, I need the criteria of a query to be one of: 4 Is Not 4 * I understand that that I can store the chosen option above in a hidden textbox (say, txtbox1) on the form, but then how do I pass the contents to my...

Thanks to some marvellous help from you guys, I have been able to import the fields in an Excel questionnaire into an Access table. I now need to populate an Excel 'template' spreadsheet with some of the Access fields. I have been able to make my database write standard letters in Word...

Hi I receive a completed questionnaire as an Excel file. I have a smattering of VBA - how difficult is it to write some code which would take an Excel file and read the value of specific cells into an Access table? e.g in English: open file C:\questions.xls tblAnswer.answer1 = cell D5...

Hi I have a database with Customers and Orders and want to write a query that will list each customer and only their last order. For simplicity, say I have tblCustomer (CustomerID, Customer Name) and tblOrder(OrderID, Customer ID, OrderDate, OrderDescription) I want the query to return...

I'm sure this is really simple... apologies, but a search hasn't thrown up any clues. I have a table with Invoice Value, and Commission Value in it. On the associated form I enter the Invoice Value, and also the Commisison value [which 99% of the time is set at 20%. I am trying to make a...

Hi - I have a recordest that is based on one of 3 queries, depending on user selection in a combo box. The queries are different - eg one includes CompanyName, and CompanyFax, whilst another includes CompanyName and CompanyAddress. I need to be able to test if recordset("CompanyFax") exists...

Very wierd... I have a 'customer' table with an 'address' field, that is free text & not linked to anything. I was messing around with a recordset created from the table, and somehow the address field in the customer table for my first record now shows as "#deleted" If I open the table in...

Hi - I have a fairly simple Access 2002 DB with about 10 tables, and all the relationships properly defined (including referential integrity). I've been experimenting with splitting the tables into a separate back-end DB, but there are only really 3 tables that are updated (the others are...

create a 'SAVE' button that will commit changes & avoid the 'before update' event? I appreciate Access by default commits changes on a form 'as they are made'. I have introduced some VBA, triggered by the 'before update' event which alerts the user that data on the form has changed, and asks...

Hi Apologies for asking such a simple question, but the solution has evaded me so far.... :confused: I have some code that creates a Word document, and fills in names & addresses using the 'bookmarks' method in Word. The line in my Access code is: wd.Selection.TypeText (Date) which results...

Hi - I have frmCompany which is the main form. There is a button on this form that opens the frmSearch form which is basically a 'Company Name' field (to allow the user to enter the first few letters of a company name), and then a 'Search' button (which builds a SQL string that modifys the...

I have an Access database, with very little VBA behind it. I want to be able to check if a user meant to change anything on a form. Using the 'Before Update' property of the form, I have got Access to pop up a box saying 'Record Changed - Save?' with Yes/No - if 'yes' is selected, the change...

Hi I am revising an existing database, and have re-designed from the ground up. My problem is importing the data from the old database - specifically, that I can't import/overwrite the new Primary Key... The old database had a customer table with CustomerID as the primary key (using...

Apologies if this is real beginners stuff - couldn't find anything from a search. I have a Company table, with CompanyID, and CompanyName. I then have a Policy table (one customer can have many policies) - with PolicyID, PolicyNumber, and CompanyID (which links the policy to the company...

Hi I have a report showing customer name, sales, and a 'commission due' column, which is a calculated field. For simplicity, lets say this field looks at whether the customer is an 'A' or 'B' customer - if A the commission rate is 30%, if B it is 20%, so I have a calculated field in the report...