Search results for query: *

Hi - I've used this code hundreds of time w/o a problem, but today is a new day. I keep getting a Type Mismatch error when I run: Dim CurDb As Database Dim rTmpNotes As Recordset Dim sSQL As String Set CurDb = DBEngine.Workspaces(0).Databases(0) 'open Temp Ship notes table sSQL = "SELECT *...

Hi All, I have a simple macro that works great when run from the View Ribbon - Macros window. It basically enters the file path & date into the document. But if I try to run it from the Quick Access Toolbar, I get an error with only an OK & Help buttons. (Help takes you no where) Any...

Hi All, I expect this is an easy answer... How do you verify if a form is already open when working on a different form? Thanks!

Hi All, I'd like to take the data from a query and list it with commas in a report text box. Query data Record # Value 1 A 2 B 3 C 4 A 5 B I'd like to display the results as "A, B, C, A, B" I know there will never be more that 7...

Hi All, I am having a "timing" issue. I have an Add button that opens a form in Add mode. The Invoice header info on top is linked by InvoiceId (autonumber)field to an Invoice detail subform on the bottom. Tables: InvoiceHeader: InvoiceID, CustId, InvDate... InvoiceDetail: InvoiceID...

I'm working on a very simple inventory form. A single form 10 fields, no sub-forms or tabs. I have some code set up that when the user moves between records on the form, it performs some data validation. It checks if the inventory item is found on an Order. If it is, I want to "Lock" certain...

Hi All, I'm working on creating a Check and my issue is on the line where it writes out "Twenty-five dollars" or whatever the amount is. I have the written words, but I need to add the "*****" to fill up the blank space. I'm missing the function that fills in the "****" for a select number of...

My project has a primary form that is launched at startup of the MS Access 2000 application. On this initial form, I define some Global variables. When that happens the Visual Basic window opens exposing all the underlying code to the end user. Is there a way to hide this? Thanks!

How do you write a SELECT statment when the WHERE has a wildcard in VBA? Example: INSERT INTO SFilterTable (ID, Field1, Field2) SELECT Sale.ID, Sale.Field1, Sale.Field2 FROM Sale Where Sale.Field1 = 11163* Essentially what I have a a Find Form where the user can choose to include or exclude...

Hi - I have a form with 3 tabs. Each tab has a subform. Each subform is based on different queries that all pull from table "A". I'm looking for a way to synchronize the record pointers across the three tabs and do it without filtering the data. Example: If the user clicks on the 1st tab...

I am currently using the DoCmd.SendObject to create a MS Outlook email with an attached Report file. DoCmd.SendObject acSendReport, rsSteamship!ReportName, acFormatRTF, rsSteamship![EmailAddress], , , "Subject line of email", EmailBody It works great. Now what I'd like to do is add the...

I've found that if the textbox data format property is "general" - all the data in the field will be highlighted as the user tabs through the fields on a screen. Now if the textbox data format property is "number" or "date" - the cursor flashes in the field and the data is not highlighted...

I have a VB6 app with SQL 2000 data that works great on multiple Win XP machines. I then installed the app on a 2003 server Sp2 with SQL 2000 and suddenly the code that use to open one window, opens 20+ windows. Essentially its an Order Entry screen and you select a button to open the Part...

Hi All, I have a continuous form that's used to enter employee time. There is a drop down box that the user selects a Pay code. The pay code determines if the user enters "Hours" or a "Flat Dollar Amount" I'm either looking for a way to have one Amount field where the Format changes...

Looking for a way to set a numeric text field to either Amount.format = "Currency" or Amount.format = "General Number" The field is on a Continuous form so I need the format to stay with the record based on my expression. I'd like to use the Format-Conditional Formatting wizard, but that only...

Through my job I've been assigned to customers who have different SQL systems.... Anyone know can you backup a SQL Server 2000 database and restore it to a SQL Server 2005 Express? or to MSDE? Is there a reason I should try to install more than one of these systems on my laptop at the...

I set up a Database/table in SQL 2000 and used an ODBC link to link to the external data in my Access 2003 project. The parent tracks Warranty Claims and the child Payments. I do not have a relationship set up in SQL. I entered some data via my MS Access forms. Two child records for Claim 1...

I set up a Database/table in SQL 2000 and used an ODBC link to link to the external data in my Access 2003 project. The parent tracks Warranty Claims and the child Payments. I do not have a relationship set up in SQL. I have a form set up with a continuous form subform. I add the parent...