Search results

How did you build your form on the 3 tables? Did you create a query that links the 3 tables and then base your form to get informatinon from that query? Whenever I make forms that use all the data in a table, In my query I use the * field to grab all the fields vs. selecting them all. I'm...

I currently have a database that keeps track of directories. Each directory has 11 sections. I set up a form for the directory that has 11 different page tabs in order to view all information on one form. I am trying to print certain pages from this form when the user presses the "print all"...

I basically am looking for VB code that will Loop my code until it goes through all records. "Print all subforms for each record" I am not very saavy with the VB syntax so any help would be very helpful. Thanks again.

I believe I have a similar problem to this previous post: http://www.access-programmers.co.uk/forums/showthread.php?t=68902&highlight=print I currently have a form that has several subform pages. I have a PRINTALL Macro that does this: GoToControl: Subform1 PrintOut: Selection GoToControl...

I have a form (FRM_X) that that has a text box w/ the primary key value (Dir Num). I also have a subform inside FRM_X called FORM_X_sub. I am trying to create a query for the subform that retrieves records like the value in the Dir Num text box. My main concern is that I also have several...

Very nice...it worked out great. I created the module, and inside the switchboard manager I put: Command: Run Code Function Name: OpenWordDoc **Note: For anyone trying this, remember to add the .doc file extension in the Network address** Thanks so much!!

In the macro design view, how would I implement that solution?? What "actions" or "commands" are supposed to be run? Thanks again.

I'm using the switchboard manager for my database. I want one the buttons to be able to open a MS Word Document. Basically, I need help creating a macro that opens a word file on a specified network address. Ex. The word file is located on the network X-Drive address...

Scenario: I currently have 2 tables, Table_X and Table_X_Import. Both tables are identical in structure. I receive my data from Table_X_Import from an Excel spreadsheet. Anyways, Data in Table_X has established data in all fields. When I import data into Table_X_Import, I only have some fields...

I currently have a macro that does a process of of appending and updating data from table to table. This macro works on the click of a button. Can someone help me with creating VB Code to run these queries without having to use macros? Generic field names would work fine to translate to my...

I have tried placing the following code in the form properties within the EVENT PROCEDURE (VB Coding Area). And I get the "Expression On Current......Error...Active X...Problem occurred" Msg. I tried putting it with the text box properties and still got the same error....am I doing something...

I have a form with a combo box with the values Yes or No. If the value on the combo box is Yes, I want the property of another text box to be shaded out or non-editable (textbox to be readable but not editable). But if the combo box value is No I want that other textbox to be accessible to...

I was wondering if I was approaching this the right way.... I have 2 tables: TableX and TableX_Import. These are identical tables with the same primary keys and fields. I am trying to use an append query to add new records from TableX_Import to TableX. After that I use an update query that...

Currently I have a form based on a query that recieves criteria from the user. The problem I'm having is whenver there are no records found for that query the form does not show up. On some of my previous projects, even though no records found, the form would show up with blank fields. I was...

I'm not so sure where to place that code that was supplied. In my situation I have a button that is supposed to open a form. Here is the code: *************************************** Private Sub Net7Results_Click() On Error GoTo Err_Net7Results_Click Dim stDocName As String Dim...

I have a form that a user chooses criteria to query the data in a table. After the user chooses the data they click on a button that opens a form based on a query that pulls from the criteria the user picked. I want to display a msg box saying "no records found" if the query has no values in...

I am appending data from one table to another. I was wondering once I use an append query to transfer data from TABLE1 to TABLE2, is TABLE2's data already updated? Are append queries the same as an update?? Basically I just want to ensure my data is saved into the table safely. Thanks for any...

I know of the "Like" Operator. It chooses records with any value that starts with..... (eg. Criteria: Like "X*"). This brings only fields that start with X. Is there a criteria operator that can bring me all the values with "X" in it, not just the begining value??

I need help creating a query that searches filters a certain field. (TelcoID) I want to be able to query certain crtiteria within the TelcoID, such as values with "X" in it. Then after querying values with "X" in it. I need to query records with "C" in it from the "X" query. For each query I...

I have a form based on a query. I have a txt box that has a field deriving from a field in the query. If someone were to alter that data in that text box, will the data in the original table be changed or just the data in the query?? Thanks for your input.