Search results for query: *

Version: Access XP After switching to XP, I tried to link to one of the tables via ODBC but this time it produced an error. This generic error message provided no specific detail. Without cycling through the Errors collection to get additional information, has anyone ran into the same...

Hello anyone, I have a form that is grouped by UPPER and LOWER (values) Turrets (name of the control). I also have a page header in my form where all records with UPPER values to print on page 1 and LOWER values to print on page 2. You will probably suggest why not use a report instead...

Thanks Sorcerer1

To MichaelRed, Thanks for another suggestion. I have actually tried the RTF as one of the option but if you see the complexity of my database, I think that you would understand why RTF just won't suffice. Do appreciate the info about using Access report.

To tangram, I too have never used Crystal report as we don't have one at work, but if that would do the trick I could request one. (hmmmm........guess have to do more reading on cyrstal report). Really appreciate the feedback! :)

To MichaelRed and tangram, Thank you both for your feedback. Unfortunately, that's the system that my company already have in place (that is using Word as their documentation but manual creation). To MichaelRed: Yes, that is what I've got set-up right now is to re-run the query and fire the...

I know this is a long shot, but what have I got to lose but ask! I'm desperate :( Pretend for demo purpose, I have 5 Word documents that consist of merged fields via automation where the fields and data came from a make-table query called ToolAssemblyID. (It's a lie, in reality we have...

B827 I appreciate very much your feedback. I did exactly what you suggested. I've got it to almost work, except it prompted me 3 times of the same parameter "Old Value" and "New Value". In your code how does it know which query to run? Again thanks for your time

In my form I have one button that when clicked upon opens a macro that updates 2 fields with related records between 2 tables. If possible I'm avoiding not to have to create 3 buttons that will open 3 different macros. Table1 is the datasource and Table2 is the recordset collections...

Disregard this post! I can see my database again!

Can anybody in this forum help me figure out what happened to my database window? I was just working on it and alt tab into another application and when I came back to it was completely blank. Just blow my mind! ........and yet window display not hidden

demoman and happen609: Thank you both for the feedback!

I am testing my database using the sample code from Northwind database and I'm trying to apply this to my application. Rather than hard-coding references to specific "Title" and value, I want to be able to use the code with other text boxes I have in my form? Private Sub...

Can anyone provide an idea how I could automatically update the destination application (in this case is a Word mail merged document via automation) whenever there's a changed in the underlying table from my Access database without having to rerun the query? Typically only the field Description...

Hello, Scope: Create Word 97 Merge Document as an “automation server” and Access as the “automation client.” Page 1 of my master document are all static texts in a table format. Page 2 and 3 are data records from a merged fields grouped by category called Upper and Lower Bound. Here’s where...

Hello, Note: Access 97 I created the Main document as a catalog merge type using a Word table where rows and columns consist of merge fields and data source is a maketable query. Here's the catch: The number of records in a recordset varies, sometimes there's only 5 sometimes 10 ...etc...

Thanks to all of you that made a suggestion! I got rid of the problem by looking harder. Carelessness on my part. I have the receiving textbox format property as a number where the control sources were all text! Sorry guys :(

Hi I have this expression in one of my textbox in a form: ="CA" & [lbxCuttingTools].[Column](0) & IIf(IsNull(Nz([txtInsertID])),"","-" & [lbxInserts].Column](0)) & IIf(IsNull(Nz([txtAdapterID])),"","-" & [lstAdapterResult].[Column](0))...

Hello, I have a form that creates a recordset. I know that not every record will have a value in a particular control, but I don't want to leave a control blank. Example: Private Sub Form_Current() If Me![txtInsert] = "NA" Then Me![txtInsertDesc].DefaultValue =...

rvBasic: All the BorderStyle for the 3 images are set to "0"