Search results

Hi, I have an aesthetic problem with one of my reports. There is a heading that needs to be on every page, showing the header of the company and the revision level of the document, but then I want to have the first sheet print signature lines under that. The report also lists fields retrieved...

Hi, this seems like a pretty simple problem, but I can't figure it out. I have a form based off one table that has people's names as a primary key, and then a bunch of fields for information about them. I want to have a combobox that lists their names, and then on the selection of the name, it...

Hi, I'm looking for some help with SQL. I have two tables, one that's permanent, and one that's temporary, and I need a command button to be able to read the temporary table and delete all the records from the permanent one that share the same Drawing Number. Then I want to append all the...

I have a report based on a table that has a Yes/No field associated with it. On the report I want to have this field represented by a check box, which is easy enough, but I also want a second box to display the opposite value, since the report must have "Affects? Yes () No()" I can't find the...

Hi, I have a command button that has to do several things at once. All of the code works out well except for one DELETE statement. It runs without error, but won't delete the records. The command button is on the form ReleaseDCN, and the control referred to is a drop-down list box. I only want...

Hello, skilled Access technicians. I have a DB that keeps track of drawings. There is one master table (Drawing Log) and then another table (Drawing Link) that shows what drawings are involved in individual products. These tables are related by the field Drawing Number. Both tables are also...

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

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

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

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

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