Search results for query: *

I figured as much, but I looked up a reserved words list and didn't find it. Thanks for pointing out the brackets, I tested by putting [LEVEL] in brackets, but I think I'm going to change the fieldname just to be safe. Thanks again!

I thought it best to just show the results of the code because it looked too messy when I put it in a post. But then I forgot you could copy paste somewhere it would read better. If ADDchk = vbYes Then 'add user ADDsql = "INSERT INTO USERtbl...

yeah the error is Run-time error 3134: Syntax error in INSERT INTO statement. I'm simply trying to submit field data from an unbound form to a table. I do a verification msgbox and when the user clicks Yes, I use this INSERT INTO statement, but it's not working.

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

Everyone and their mothers are involved at this point. I'm not really trying to diagnose the problem. They've said it's a firewall issue. I'm just curious if it really can be a firewall issue or are they just feeding me a line. NOBODY can use the program right now. Not me, not any of the...

Did I mention I'm just talking about logging on. I'm not talking about using the software. I understand a couple, 10 or even 100 testers can't possibly replicate the 1000's of users possible problems. I'm talking about accessing a website and logging on. Am I still being unreasonable for not...

I appreciate the quick responses. Ok, I'll concede there could be issues with the firewall. But seriously 4 days and they can't figure it out. As to the size of the company, it doesn't reflect the number of users. There are probably 400-500k employees, but only 5-10k users of this service...

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

Nevermind... On the frmMAIN, on the button that opens the frmREPORTS I had a couple lines of code. One pointed to something that I didn't think affected anything. But there was another line of docmd.movesize code and when I added the with forms!frmREPORTS it worked fine. Can I give myself...

I know you didn't ask for this answer, but you could make the program auto-assign the CSR's name based on a table. There is code on this site that pulls the NETID of whoever is logged on. For instance, I'm logged on my computer right now as "jeffrey.loehr". If your company uses a similar...

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

Are you users opening up the form on their own computer. Meaning if you are using this at work are all the users logged in with their network id. If so, you could use the network id to identify them and track them that way. Look up fosusername in a google search and you should find it. I'd...

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.

I tried it and it still didn't work... let me give you the whole code: Dim DB As DAO.Database Dim rst As DAO.Recordset Dim sevendaysql As String sevendaysql = "SELECT DISTINCT * FROM REDBALLtbl WHERE REDBALLtbl.CT = BETWEEN #" & Format(DateDiff("d", 7, Now()), "dd-mmm-yy") & "#...

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

Thank you very much... Sorry it took so long to reply. Been working on many different projects. I did test the code from the link from Migs01. It worked great. ~A.J.

Just tried Transparent .gif.... Didn't work either =(

Appreciate the attempt MajP... however it didn't work for me. My images with transparent backgrounds still showed as white. And even a Textbox I have .visible = false showed up white. That's weird. There were areas that were transparent though, anywhere that didn't have an object of anykind...

No I haven't tried a .gif. I thought if a .png wouldn't work... neither would a .gif or .bmp. But I guess that (although it may be right) is a stupid way of looking at it. I'll try some more file types before giving up on the idea. Thanks for the reminder.

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