Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. curlydog

    Conditional Hyperlink In Report

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

    Conditional Hyperlink In Report

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

    Conditional Hyperlink In Report

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

    Automating Entries Based on Dates

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

    DoCmd.RunSQL Woes

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

    DoCmd.RunSQL Woes

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

    DoCmd.RunSQL Woes

    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 &...
  8. curlydog

    AutoFill Textboxes

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

    AutoFill Textboxes

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

    AutoFill Textboxes

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

    AutoFill Textboxes

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

    AutoFill Textboxes

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

    Obtaining TextBox Values Via SQL

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

    Obtaining TextBox Values Via SQL

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

Part and Inventory Search

Back
Top