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

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

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

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

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

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

Hello, I started a standard exe in VB6 called Butterfly.frm where there are 3 images called OpenWings, CloseWings and Main. My problem is: during run-time, noticed that the frame is visible and I could not find in the properties of the Image control to make that invisible. Thanks!

If a new record will be similar to the previous one, automatically fill text boxes with that data for the user to edit. On my form, in the BeforeInsert event, I have: Call CarryOver(Me) In the module called basCarryOver this is my code: Sub CarryOver(frm As Form) On Error GoTo...

This code was the example code in Q159328 of Microsoft.com and applied it to my form. It worked fine except it's supposed to pull the data from a 3 parameter query. When I changed the line of code to this: Connection:="QUERY qryToolAssy", _...

I don't want to use an Update query if I can avoid it because I need to automate this task and to be as user friendly as possible. I need Access to provide the ability to StoreValues() from the current record and RestoreValues() for the next 9 subsequent records in a recordset. For example: A...

I was testing a function per Q159328 - ACC: Example: Mail Merge a MS Access 97 Query with Word 97 document. I would like to point out that I am using Windows 2000 Professional. Yesterday I got it to work but this morning when I tried the code again in the Debug window, aside from taking...

Help! I think I'm stuck: I was testing a function per Q159328 - ACC: Example: Mail Merge a MS Access 97 Query with Word 97 document. I keep getting this error: MS Run-time error '5273': The document name or path is not valid. But I know I have the correct path. This is my code: Function...

Hello, I have a combo box that has 3 fields: Ex: ID:1 (column 0) Station:8Upper (column 1) Display:8 (column 2) Although I still want to show all the 3 fields to the user, but I want the Display field as a result. How do I do that?

Hello! I have a form where I have to extract different values to create an assembly. I have extracted 3 records so far and everything seemed to be working fine. I have followed the same steps through out. When I came to the 4th record something went hay wire because I keep getting this...

Hello, I have a form in Access 97 that consists of textboxes, combo boxes, listboxes, etc where a user have to extract different values to create a partslist. Perhaps nine line items in a partslist, each task differs from another. The first record is then transfered to the second form. On...