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!

  • Congratulations dencom 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: *

  • Users: AJLoehr
  • Content: Threads
  • Order by date
  1. AJLoehr

    INSERT SQL giving me problems...

    what's wrong with this syntax? INSERT INTO USERtbl (EIDP,RANK,FIRSTNAME,LASTNAME,OFFICE,PHONE,EMAIL,LEVEL,RIGHTS) Values ('john.doe','Mr.','John','Doe',19,'318-555-5555','john.doe@gmail.com','Company','Admin') All fields are 'Text' except for Office which is a 'Number'. I thought maybe one...
  2. AJLoehr

    Firewall question...

    This is a very generic question about firewalls, I'm sorry I don't have a lot of the specifics. I use an oracle based reports program to pull data from a server. The program I use is called Discoverer. Recently the server administrators updated the software and now I cannot log into the...
  3. AJLoehr

    docmd.movesize on popup forms

    I have 1 form (frmMAIN) set to Popup and Modal. On it, I have a button that opens another form (frmReports) also set to Popup and Modal. frmMAIN has the docmd.movesize var1, var2, 4800, 1400 frmMAIN also has a timer running on it and basically shows time on a label format(now(),"HH:NN:SS")...
  4. AJLoehr

    PKI Certificate

    Is there a way to use a PKI Certificate on an Access Form in order to get signature information. I don't want to steal the information, I want to use the information to digitally sign the document.
  5. AJLoehr

    Help my SQL please... simple SELECT with ISNULL

    I am trying to pull all records from REDBALLtbl where REDBALLtbl.CT (date) is between today and 7 days prior to today PLUS (AND) REDBALLtbl.TT (text) is NULL. sevendaysql = "SELECT DISTINCT * FROM REDBALLtbl WHERE REDBALLtbl.CT = BETWEEN " & Format(DateDiff("d", 7, Now()), "dd-mmm-yy") & " AND...
  6. AJLoehr

    Transparent Form Background

    Ok, first off... I know this topic has been discussed probably more than any other topic EVER. But I still can't find any code to work. I'm using Windows XP (at work we use Vista mainly and some XP). I'm building the program in Access 2007. Here is the code I found... sorry no references...
  7. AJLoehr

    click a label, pass some code...

    I'm trying to make an access form to simulate a Sudoku puzzle. So if you know Sudoku and you understand what a "Candidate" is... you'll know there are 729 candidates on a standard Sudoku puzzle. So I have 729 labels. I want to be able to single click a label and set the label.caption to the...

Part and Inventory Search

Back
Top