Search results for query: *

Right, I've sorted this out and will post this answer for the benfit of other beginners with a similar problem. The problem appears to stem from how Access renders different views of the report. I want an event to fire each time a record from my query is rendered to the report. Hence I want to...

Oh. It runs as I switch from design to report view.

Hi, I'm having trouble adding a hyperlink to a report. My underlying query has a field called LinkLive. If LinkLive has a value for a particular record in the report, I want the hyperlink to appear and work for the user ( The report will be exported as html). If linkLive has no value stored for...

I'm developing a database that stores data concerning overtime in a department. I have some (limited) knowledge of programming but I'm new to VBA. On the 26th of each month, a fixed amount of overtime hours are added to the department's overtime budget. I'm trying to automate the process of...

One thing that Access does when I insert the data is throw up a message box telling me that I'm about to append data to the table, and do I really want to do this. This will get very annoying if inputting a lot of records one after the other. Can I stop this message box. Ta Jason

Just figured it out after finding a post in another forum. "date" is a reserved word in SQL. I changed date to adate and it works fine.

Can anyone tell me why this sql won't work? I'm trying to append to a table using values from a form. this is the code; Dim strSQL As String strSQL = "INSERT INTO tblOTStatement (caseNum,officerPK,otSourcePK,hours,date) VALUES (""" & cmboReason & """," & cmboSurname & "," & cmboSource &...

Yes the form is bound to the table. But if the form tries to save changes when I update anything why does this problem only occur when I tab out of the combobox? I don't have a problem if a). I type my value into the combobox and then click in the next box with the mouse. Or b). I select the...

There is a foreign key relationship between the two tables, but not concerning the column from which the combobox is filled. The column from which the combobox is filled does not reference anything. The foreign key relationship relates to a column to which the textbox I mention is bound. When...

Although the combobox is bound to a column, the column that it is bound to is not required. The column from which the data is retreived has the properties (in table design view) Required=No Allow Zero Length=Yes Unless I'm missing another property somewhere, I can't see that a value from the...

For the first bit I did change to a combobox, but it's created a strange problem of it's own. When I press the "tab" button to get out of the combo box, I get an error saying "You cannot add or change a record because a related record is required in table 'tblOTSource' ". It's strange as it...

I have a form that receives information that may well have been input previously. I'm trying to make the inputters job a little easier. The first textbox takes information that is likely to have been previously input. Is it possible to have the textbox autofill depending on the first few...

Sorry if it wasn't explained too well. Basically I'm trying to find the sum of values and display them in a text box. I want the query to sum values based on the data in another text box. At the moment this is the SQL have as the controlSource of the textbox; =(SELECT DSUM(hours) FROM...

I'm putting together a database that records overtime worked. The overtime can come from one of several budgets. I want to show how much has been added to each budget, and how much has been spent from the budget on a monthly basis. The problem I have is that it may be the case that if no money...