Search results for query: *

Basically, I am attempting to combine 2 queries into one. To simplify it, I have a customer table, a Sales table, and a Refund table (whose structure matches the Sales table). I need to report an aggregate by month, returning the following format: Month Cust ID Cust Name Sales Refunds...

I have a form within a table and it's been requested that if a certain selection is made from a combo box in the form then another combo box will become visible. The way the asp page is coded (by someone else prior) I'd prefer not to have to submit the form and display it again. I'm not sure...

I have an Access database that has several SQL Server tables linked (though not used in any queries..instead I use pass-through queries). I am trying to create a report where the recordsource is a nested query where one of these pass through queries is used. Whenever I try to do anything...

I am dynamically creating a table where the field names will change everytime the code is ran. My issue is there are several times where the name passed through will contain the '%' character (and possibly other harmful characters). This causes my code to error out. I would prefer not to have...

I have emails that come in with standardized subject lines and standard formatted bodies. I need to take the information from the email(date, from, subject, and specific data from the body) and enter it into specific columns within an Access database. Not sure if I would have to do this in...

I have several text boxes on a report that are made up of concatinated fields and strings but in the middle of this I need 1 word to be bold & underlined. Everything I've tried has left the word in the same format as the rest of the main text box. I need to find a way to make just this one...

I need to convert an Excel Spreedsheet that uses the CumiPmnt() Function into a report in an Access 2000. As far as I can tell there is no way to do this. Basically the calculation is used to determine the finance charges on a loan using the actuarial method, which as I can tell also is about...

I have an Excel spreadsheet in which every field is formatted as Text except 1 Currency & 1 number field. I've automated the importing of the spreadsheet using the .TransferSpreadsheet code. Occasionally, I get a Numeric Overflow error. For some reason, Access 2000 doesn't give any Import...

I'm using Access 2000 & am trying to automate a process for another person. I'm getting a type mismatch where I indicate below. The next line of similar code runs fun, but for some reason it doesn't like that one line of code. I've tried Dim a string variable & putting it all in there & then...

Okay, I'm in an multi-user enviroment & most of the time they use multiple databases. The frontend of the database has to reside in a specific path on the users machine depending on what type of machine the user signs in on (which I can obtain by getting the username from the system). I've...

I have an Access 2000 database. While testing/fixing code I'll put in a breakpoint. Then I fixed the code removed the breakpoint then go through normal procedures to run the code. The VB Editor window comes up with the line on which I had the breakpoint highlighted, but there is not...

Okay, my company is currently updating everything to 2000. Therefore, I'm having to go in & change all my VB code from DAO to ADO to connect to Access 2000. Everything's been a breeze until the current code. I've changed my connection, removed my .Edit & .OpenRecordset references. Now the...

I am connecting to an Access 2000 database through VB6. For some reason it doesn't like the .Edit on my ADODB.Recordset object. It gives me an "Method or data member not found". Here is an example of my code: Public gdbDatabase As ADODB.Connection Public gdbTableO As...

I am connecting to an Access 2000 database through VB6. For some reason it doesn't like the .Edit on my ADODB.Recordset object. It gives me an "Method or data member not found". Here is an example of my code: Public gdbDatabase As ADODB.Connection Public gdbTableO As...

I am wanting to get more information on how to create & utilize the database library idea so I can share between the several databases I've created. I also want clarification on how the new version check quits the current database, makes a copy, and starts the new version.

I have a table/query/recordset that has several columns. I want to match the names of the columns to other values. If the name matches I want to take the name of the column and make it a data value in a column of another table - sort of a reverse crosstab query only instead of taking values &...