Search results

I am creating a table using a make table query. The data from the table is used in a mail merge Word document. I noticed that the data entered in text boxes is not displaying in the word document after the mail merge is completed. Then I discovered that the text data is created as binary in the...

I need to add 7 days to an existing field and store in a different field in a table for use in a mail merge document. What is the syntax for doing the calculation and storing it in the first occurance in the table? Thanks very much, jketcher

I recently got some help with filtering data in a table using multiple combo boxes. Now I need to export that filtered data to a text file. The data is displayed in a subform [Marketing subform]. How do I do this? Do I need to create a recordset from the data that is displaying in the subform...

Need help with this. Getting errors every time I run it. I am selecting a text "1" or "2" or "3" or All from a combo box. I started out coding this directly in the query but ran into problems because I have five combo boxes on this form and found it easier to do VBA (I think) for combox that...

I am attempting to create a form that uses multiple combo boxes to provide selection criteria for a query that is run when a button is submitted. I am stuck with syntax errors and other types of errors when I create a DoCmd.RunSQL "SQL code copied from a query". I am using this as the base to...

I have a new project. This time I am using several combo boxes but will be happy if I can get the first one to work for now. It is unbound and has three selections that will be used as criteria for a query that displays output in a subform on the same form. I think this is a very basic scenario...

Hi, It was suggested to me that I use the 'switch' function to translate codes from a table/query into meaningful descriptions. I do not know how to do this. Is it done at the table level or can it be done in a query? eg. 1 = public, 2 = private, 3 = proprietary Do you have some examples...

I am getting the following error message when running an append query. It only happens when I am using two of about 200 records from an existing table. The message is: 'You cannot update this field because the value you're trying to apply is not valid or would break a data integrity rule...

Getting a compile error 'user defined type not defined' on the 'Dim objWord as Word Document' I researched the internet and found that I might have a problem with the Object Library from the References tab when the Module sheet is open. My Access installation has 'Microsoft DAO 3.6 Object...

Back again... New subject. Tabbed form with 'Client' selected on first tab and used on the other tabs. The fourth tab (Run Reports) has a subform that uses the client to query records but when the client is changed, the records are still for the previous client. The client change shows on the...

My assignment is to create a button on a form that will activate a query that creates data for a mail merge document. This has to be done in mail merge. Would someone please give some guidance. My ultimate assignment is to try to get this to work with one button press from start to finish but...

Help again! I think I have a syntax error with a SetFocus command. I am trying to navigate back to a specific place on a different form and it is ignoring my code. Forms!Switchboard!AddFindings.SetFocus After an error message displays, I am attempting to navigate from a Form named...

I am stumped. This is working fine on another form in this database. What are the reasons for a SetFocus not working? I am displaying an error message if the user leaves the control without entering data (LostFocus). I then set the border on the control to red - works fine, but when I try to...

Help please! This may be the beginning of a string of questions. I am developing a new tab in my database that uses a field 'Client' that is entered on the first tab and originates from a 'Client' table. For this 'Client' a list of students and identifying information needs to be entered into a...

Hi! I have several places in my code where I am performing the same initializations. What is the syntax for setting up one routine that can be performed from multiple places in the code? Thanks, jketcher

Hi, !never mind I figured out that I needed to do a Requery on the subform) Thanks anyway! Needing a little more help. The database I am working on consists of four tabs with data from two tables. The form in question has a subform that pulls in a 'Description' field. The problem is that it...

Hi, I am working on some code that will check a combobox entry (category)against a table for duplicate entries. The code is working (with help from your colleagues) to display a msgbox that will redirect the user. But, no matter what I enter to redirect the focus and end the sub routine, I get...

I need to navigate from one tab to another tab depending upon results of some If/Else code to edit combo box data. Here is the code that works to produce an error message if a user has made an invalid selection. When the msgbox pops up and the user enters ok, how can I display the correct tab...

I am new to developing VBA code and need some expert recommendations. I have two bound combo boxes that are based upon non-key fields. One holds a list of clients of which one will be selected by the user (Client). The other holds a list of Categories for entering findings (Category). A client...