Search results

  1. G

    Who is corrupting my database?

    I have a database running on a Citrix server to serve multiple users. It was in Access97 but I recently converted it to Access2002. Since then the database seems to report that it is corrupted quite frequently. I suspect that a user is causing it by powering off without closing down. The problem...
  2. G

    Query output to a text file

    I want to run a query which will also include some expressions made up of html. The idea is that I can use the output of a query to generate an html page that will just require <head> and <body> wrappers. I can create a 'make table' then export it, but is there a way to do it directly from the...
  3. G

    How to report record just inserted?

    I have a subform which shows prices for a given supplier that relate to a product (the mainform). The user clicks on a command button in the subform to create a new order for that supplier/price and the pop-up has a confirm button that when clicked runs an INSERT SQL statement to add the new...
  4. G

    Changing recordsource for a form

    I have a form whose recordsource is set to SELECT * FROM [Order] which I want to change to a single specific record using while testing) as a click event on another form using: Dim SQL As String SQL = "SELECT * FROM [Order] WHERE ID = 72" Forms![Review Order].RecordSource = SQL DoCmd.OpenForm...
  5. G

    Identify when INSERT query fails

    I have searched on the forum but am a bit punch drunk by all the information here! I have the following code: Docmd.setwarnings False Docmd.openquery "insertquery" Docmd.setwarnings true However, if the query fails (e.g. violations) then as the warnings are 'off' it just gets ignored. If they...
  6. G

    Deletion event

    I want to detect when a record in a form is actually deleted i.e after the user has actually confirmed deletion. At this point, I want to be able to perform some additional processing - put back into stock the quanity of the item previously issued that is now being deleted. However, the...
  7. G

    Switchboard form gone

    I was playing with the switchboard as generated from Switchboard manager and then deleted the form. Now I try to go back via Tools..Database Utilities...Switchboard Manager and although I can see and edit the structure I originally specified I cannot get the physical form to recreate (ie does...
  8. G

    Text selection on cancelevent

    I am sure this must be very simple but.... as the 'Before Update' event for a text box in s asubform in datasheet view, I perform some validation and if it fails send a msgbox then 'cancelevent' (in a macro). Although the box still has the focus, I would like the erroneous value...
  9. G

    Multi select combobox - order clicked?

    I have a multi select combobox which will contain a variety of remedial actions taken to a problem e.g. cleaned, repaired, replaced, removed, adjusted etc I want to use these selections to automatically create some text so to make sense, the order of selection is important eg removed, cleaned...
  10. G

    Subform new record conditioning

    Hi! I have a subform (continuous forms) that includes a command button to perform a task for each of the individual records. However, I also get it on the 'new record' at the bottom, which is not appropriate. I would still like the user to have the opportunity to add new records so I dont want...
  11. G

    Oh no! Not another cascading question!

    Sorry everyone - it looks like that this has been done to death, all except for this question...... I have a combo-box (cb1) from which a user selects a value (row source = a query), When the user make a choice, the 'after update' event runs a macro that performs a 'requery' on another...
Back
Top Bottom