Recent content by ComptechRx

  1. C

    Append data to table

    lol I forgot to mention that when I run the Query, it doesn't actually do anything. It says a number of records will be affected but after clicking ok, nothing gets written. After doing more searching it looks like an Update Query might be better since there are existing records? Right now I am...
  2. C

    Append data to table

    Thank you in advance to all who can shed some light on this question. I have a table called dbo.userinfo with a primary key called employeeid and a field named jobfunction. i have an intermediate table named dbo.projectpositions with a primary key named projnumber and a foreign key named...
  3. C

    Creating Northwind database tables

    Awesome! Thank you very much JD!
  4. C

    Creating Northwind database tables

    Can anyone recommend a book or tutorial that shows how to build the kind of tables that exist in the Northwind sample databse? I would really like to learn how to create the kind of tables where I can relate multiple records like the image shows. TIA
  5. C

    Adding increments to a field

    Hi All.. this is going to be tough to describe but hoping someone can give me an idea on how to accomplish what I need. I have a query named qryActivityRefDetail based on some relational tables and is set as follows: SELECT DISTINCT tblActivity.ID, [tblActivityType]![AcitivityTypeRefID] &...
  6. C

    Remove all data from Column without deleting field

    What if you want to delete all data in a Memo filed that is set to append? I tried using the above method, but all it did was add blank entries which were recorded.
  7. C

    Pull columnhistory based on date?

    Any updates on this question?
  8. C

    ColumnHistory Use in Queries

    Does anyone know if it's possible to print the full ColumnHistory with dates and all entries in a report? I tried adjusting the fields to show more lines but that didn't do it. I currently have the report pulling the ColumnHistory from a form. TIA
  9. C

    Pause Access to allow VBS script from hyperlink to run

    Thank you for the response. Unfortunately editing the VBS script is not an option, I have to get the code to do what I need it to do within the database. If I can see what the code would be to have Access run the hyperlink associated with a control, in this case, a text box, I believe I'll be...
  10. C

    Pause Access to allow VBS script from hyperlink to run

    I came across some simple code that adds a pause when clicking the field that contains the hyperlink: Public Sub fnPause(dblSeconds As Double) Dim sngTime As Single sngTime = Timer + dblSeconds Do Loop Until Timer > sngTime End Sub Code: fnPause(X) ' X = the number of seconds to pause...
  11. C

    Pause Access to allow VBS script from hyperlink to run

    Thank you very much, I will give that a try. Will also like to hear of any other solutions that are available and less complex in terms of code. Thanks again!
  12. C

    Pause Access to allow VBS script from hyperlink to run

    We use the VBS script to create local copies of project files for us. Each script gets placed in a project folder. I use the drag & drop feature in Access to store the location of the script file as a hyperlink in a field. This way I can manage all the paths for all projects in 1 database and...
  13. C

    Pause Access to allow VBS script from hyperlink to run

    Hi all, I've got a form set up with fields that have hyperlinks to vbs script files. What I'm looking to do is have the user click the link so the script will run and then have Access close automatically so the user doesn't leave it running. I've messed around with Application.Quit as a macro...
See more
Back
Top Bottom