Search results

Oh, I'm sorry, I completely forgot. Now it is just giving me syntax errors in all three. When I tried having a notice just titled TEST, even though this made a log called TEST Log, the error was "cannot locate table or query 'TEST' " Now it's just looking like all of them are written wrong...

Hi, I'm learning SQL (and Access for that matter) as I go, so I apologize for having terrible syntax, but if you could help me anyway, it'd be a lifesaver. In my DB there are notices that are issued that make revisions, additions, or deletions to drawings. However, some of these notices do not...

You could put both of those groups of code into the OnChange event of the control for your Primary Key, which I'm guessing is the autonumber field ID. What exactly do you mean "but it works when it wants."?

wow, that's awesome! This will make things much easier for my user, Thanks!

Where would I put that code so that the names would show up in a combo box?

I know this isn't exactly related to the original post, but is there a way to use the object MySysObjects to return a list of table names based on a criteria? Like all the table names starting with numbers? An SQL statement wouldn't work because the WHERE clause would apply to the table names...

I don't know how common this problem is, but it was vital for my situation, and there isn't a set way to do it in Access. If you have a Report that displays a 'cascading' type recordlist (many records based off of one field placed in a Header) and want to have the individual values of the header...

Thanks, Rich. I kept running into trouble and then realized that it had to be in the Private Sub PageFooterSection. Works great! Thanks

Hi everyone, I was wondering if it's possible in VB to create code for a report so that for each individual value in the group header section there is a different page numbering system (if there's three pages under product 1118, even if they're the 50th page in the report, it reads "1" "2" and...

"Just use [Forms]![Add Drawing]![Drawing Number] in the criteria row" Sorry, I think I didn't explain it correctly. Each of the three forms has a [Drawing Number] control that I would like to be able to fill the parameter and I'd like it to work with just one query (I could do it with three...

Hi, everybody. I'm wondering if it's possible to fill a parameter in a query using VB without the parameter messege box coming up. The query, when performed, can return any number of results, and I then need to be able to add new ones, so I don't think that opting to put the SQL right into VB...

Thanks, Keith, it's working fine now. I knew that it was some arrangement of quotes, but I couldn't figure it out, either thinking it through or jmust trying everything I could think of. I'm very new to Visual Basic and have no resources besides the help files, which have some gaping holes when...

Hi everybody, What am I doing wrong with this statement? DoCmd.RunSQL "UPDATE [Drawing Log] SET [Current Revision] = & "'CurrentRevision'" & " WHERE [Drawing Number] =" & "[Forms]![DCNs]![DCN Details Subform]![Drawing Number]" I have a form that displays records about drawings and I want to...