Search results for query: *

How do I handle an error within the append query? I know the error that I want to handle is conDuplicateKey = 3022, which is a duplicate key error, but I don't know how to reference this error. Can I even do this is a DoCmd command? My code is below, any help would be great! Private Sub...

I'm currently using a form to set the criteria in a query and I'm wondering if there is a way to do that with a module. Specifically, I want to change the CD_WR using a form. The SQL is below: Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String strSQL = "SELECT WRInquiry.*...

I've got the main form, which is populated via a query. The subform that's on the main form is based on the table that I want to populate. The subform contains records that users can change (just certain ones) and it also contains all the records in the table. The records the user can not...

Is there a way to reference the data in a pivot table field in order to manipulate the data. For instance. I have a month field and I want to be able to choose a month "say month 10" and have the month fields on my Pivot table show Month <=10, so 1-10, but "click off" months 11 and 12. If...

I'm trying to make a design master of a database so that I can update the database on a citrix server and replicate the changes to another server. When I replicate the database my autonumber field value changes from Increment to Random. Also, I have a Date Ran field that enters the current...

I'm able to run a query in Access successfully but I get a driver error when I try to access the query in Excel. I'm trying to use the query to create a pivot table in Excel? The error message is "[Microsoft] [ODBC Microsoft Access Driver] Invalid value for cast specification on column XX."...

I'm able to run a query in Access successfully but get a driver error when I try to bring it over to Excel in a pivot? The message is "[Microsoft] [ODBC Microsoft Access Driver] Invalid value for cast specification on column XX." Any ideas?

While reading in a text file using the scipting.text string, I get an error when and apostrophe is encountered. Any ideas how to ingnore apostrophe's?

In Excel, I use an index to build a record set that I need to import into an oracle table and I can't do that anymore as my record set is now to large for Excel to handle. Can I do something similiar in Access? What I need to do is look at a set of records for a specific criteria and if that...

I'm having problems with my macro's because I'm using a template to pull out data and saving that data to individual files. Now my original macro in the tempate file doesn't work. I'm thinking this is because Excel saves the macro file as a bas file and is overriding my template file. Does...

Run-time error - 2147417848(80010108) Automation error The object invoked has disconnected from its clients All I'm doing is cutting a column and inserting it to the right of another column and it's failing. I can't find anything on this error. Can someone help?

Does anyone know how to set a filter based on a variable picked on a form? I can find how to get the value of a filter that has been selected, however, I want to do the opposite. I want to set the value of the filter based on criteria my user selects. Any ideas? If I can't do that, then does...

I'm trying to filter a list based on a value picked on a form. When I execute the following code, I get an empty value for my h2 field. Any suggestions as to why this may be. I was populating that h2 value using a lookup, however, I even tried to hardcode it and I still get and empty value...

Is there a way, when creating a pivot table in Design View, to not have the records populate as you design and just have the field names (like Excell does). Then when you switch to page view have the records show. I'm creating pivot tables on large databases and it takes so long because the...

I need to hide and unhide rows based on criteria from a drop down box. I recorded a macro to do this, however, since the first column in these rows are merged, the macro hides all the rows that are merged. The only way around it that I've found in to unmerged the first column hide/unhide the...

I'm linking from Access to an ODBC database and the datatype for a field is a number. When I view the design of the table in Access the datatype is text. Can I use VBA code to link this table and keep the data type as a number?

I'm linking from Access to an ODBC Database with a data structure example below. FTE(number30,2) Amount (number30,2) and when I link the file access interprets it as text. FTE (text) Amount (text) What can I do to correct this problem?

I'm currently using a form to set the criteria in a query and I'm wondering if there is a way to do that with a module. Specifically, I want to change the date in the WHERE statement in the code below: Private Sub Calculate() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strSQL As...

I need to compare one field (WR) in the database to the previous field (WR) and if they equal performe a calculation (daydiff-daydiff). I need to loop through the entire database. read second row [wr] field If equal to previous row [wr] field [daydiff] previous record – [daydiff] current...