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

I had done that but kept getting runtime errors. I finfally got fed up and deleted the form and started from scratch and it's working fine now. I guess in trying to do it I flipped the wrong property accidentally and it was doomed. Sorry to bother you with such a simple problem, but thanks for...

it comes up with a runtime error 3021 : no current record whenever I select from the combobox

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

Never mind, dumb mistake forgetting to define the variable. The SQL works like a dream, thanks!

Now it looks like this: strSQL = "Delete * FROM [Drawing Log] WHERE [Drawing Number] In (SELECT [Drawing Number] FROM [" & DCN & " Log])" DoCmd.RunSQL strSQL but that's got a syntax error. Do I need the parentheses?

Here's what I had: strSQL = "DELETE [Drawing Log].* FROM [Drawing Log] WHERE [Drawing Number] = [" & DCN & " Log].[Drawing Number]" DoCmd.RunSQL strSQL and it just prompted me to fill in the parameter (ex. '07-31 Log' in an input box)

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

Well, I was about to make another stumped post, but then I realized that I had somehow switched the bound and unbound check boxes while I was checking after your last post! It's working great now, thanks!

The unbound boxes just stay gray and don't change, even if I switch the wording of the IIf statement

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

Thank you very much, ByteMizer. That code worked very nicely!

No, that kind of confused it a little more. I decided to try to get right to the point and go with a delete query: DELETE [Drawing Link].* FROM [Drawing Link] INNER JOIN [DCN Details] ON [DCN Details].[Drawing Number]=[Drawing Link].[Drawing Number] WHERE ((([DCN Details].[DCN...

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

Ok, I have found a way to work around the problem. After much searching, I found the code to establish relationships, but it turns out that the version of Visual Basic that we are operating with doesn't recognize the type 'Relation' or 'Database', as in Dim newrelationship As Relation. Instead...

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

ehh, it's not letting me. It's probably my terrible computer here at the office. In any case, I've figured out where my coding issues were. Learning as you go means a lot of hair-tearing. But it is slow and steady. Stuff is getting finished. No small amount of that is due to all the help I've...

how do I attach the DB?

Oh, wait a minute. Now it's coming back with 'cannot locate input table or query 'stDocName'

thanks, Keith. That fixed up the problem. I had tried bracketing, but forgot to put them inside the quotes. SQL runs circles around me. Now the problem is that the SQL runs and nothing happens on the table, but as long as it's written right and runs, the data's going somewhere, and I can find it...