Search results for query: *

I don't see what I'm doing wrong with this update, no error occurs, but no update either. Both rec2 and rec5 are ADO. rec2 comes from Oracle, rec5 from Access. Do While Not rec2.EOF With rec5 .MoveFirst .Find "[po] = " & rec2!PO_NUMBER, , adSearchForward...

I use this code to sum up column 9 into a list box whenever its requeried but if there isn't at least a $0.00 in the column it says I have a data type problem. It's hung up on the NULL's. The data type in the table the value is held is set to currency. I've tried NZ, I've tried Format...

My users have 3 values from a combo box to chose from which is used to isolate the data they need to a listbox. I'd like them to have the ability to retrieve all data if the combo box is blank. How can i accomplish this? I've tried using the 'Switch', 'IIF', and 'NZ' funtions in the crieria...

I'm trying to link a listbox on page index 1 (second tab from left) to a subform on that same page. Seems like it would be easy but it's not taking anything I give it. Subform would keep notes to each record in the listbox I select with the mouse. Tab Control: TAB_CTRL_PAGES Page...

I find it hard to believe that this doesn't work in A03, is it true a03 will not do a transfer spreadsheet to excel 07? I usally can't find the little secrets around this site so I'm asking here. Option Compare Database Private Sub cmd_XFER_2007_Click() Call XFERExcel2007 End Sub...

I have 3 items I need to consilate, but I can't lose part of the detail. Right now 3 lines look like: INVOICE DESC AMT 123 TAX 5.00 123 FREIGHT 7.00 123 PAPER 9.00 Need it to 1 line and look like: INVOICE DESC AMT...

I need a function or something that can give me a bucket that increments by 1 at each change in data that is not unique (but it is sorted correctly)... See below, I need to produce the GROUP_ID at every change in invoice date then line_number (notice invoice date is not unique, niether is line...

I have a form that enables the user to select an excel file they can import into the database. Problem is that some of these excel files get saved on accident after someone has changed the columns. The user gets "Run-time error '3274': External table is not the expected format." Is there a...

There have been a lot of posts on Run-time error 2391 but I have never seen an answer to it: Private Sub CMD_IMPORT_NEW_DATA_Click() Dim varDate As String Dim varSpecification As String Dim varTable As String Dim strInputFileName As String varTable = "TBL_AR_AGING"...

Using WinZip I can zip one file with the following code, but I'm having problems getting more then one file into this winzip file. Private Sub Form_Load() Dim ZipPath As String Dim ZipFile As String Dim ZipApp As Shell Dim strpath As String Dim today As String Dim fol...

The other day I was making a change to a cmd button on someone's front end and put in a couple breakpoints to get it fixed. Well now everytime the cmd button is pressed the DB stops where I put my breakpoint - I hit debug on the error msg and sure enough its where I put my breakpoint but its...

I would like to take: INVOICE|QTY 12345 |500,400,700,600 And turn it into: INVOICE|QTY 12345 |500 12345 |400 12345 |700 12345 |600 Any sites or previous links you know of? I couldn't find anything.

I have a little form where you type a vendor number and it goes to that record in the database, the vendor number is a text field in the table and the text box on the form has no formatting to it, but it says I have a data type mismatch, not sure why. Private Sub cmd_GoToVendor_Click()...

My dollar amounts look rediculous in this list box - is there a way to right-justify a specific column in a list box?

How do I keep an ODBC connection open so that any form can use it to extract data from an external at any time rather then having the Access DB log in the the external DB on every form? The DBA's are upset that my db's are loging in 200-300 times a day from my users into the Oracle DB and want...

I'm trying to give the user the ability to update a combo box to null if they no longer want a value from the combo box on the main table. varSalespersonID = IIf(IsNull(Me.cboSalesPerson.Column(0)) = True, "", Me.cboSalesPerson.Column(0)) It's the INSERT statement that doesn't like the two...

We have several users that have mapped their drives to the same place with different drive letters due to face that other departments cannot change their drive letter because of their access DB's, and we have to hit their databases. Is there a way of bypassing the linked table manager settings...

I keep searching but can't find this question ever being asked. How do I extract the field names, data type, and field description from an Access table via SQL or a Query? I don't see any table column name data in the Msys tables.

We have a shared windows network here and several access databases on it. They are all split, but very slow once more then one person uses them. I noticed recently that everyone has shortcuts to the front end and not the actual front end sitting on their desktop. The front end and the backend...

I need to compare 4000 records in Access to another database (Oracle) using SQL via the IN function. It's limited to 1000 expressions, which means I need to split it up 4 times and run the SQL 4 times or create 4 IN statements in the SQL, which I would rather do so that I only run this query...