Hi Experts,
I need your help!
I am creating a function to help me to extract information from a messy data set.
I tried to use a select statement in vba.
however, i tried to use the...
I have attached a file (Excel). This is a sample file of an regular download from SAP. I run that Job on a daily base and save the results as an .xls file, but the Data is almost like "throw...
I have an Access application (originally created in Access 2003 and now running in Access 2007) that runs a series of queries and then does a docmd.transferspreadsheet. When I run the queries...
I want to import information from a textfile. I wanted to see how I can setup the specification name (schema.ini) to import the file correctly. Below you will see a sample of how the data I wa...
I've got a Sharepoint list linked into an Access 2007 database. Through code I'm trying to update fields in the list, but get a message saying "Database or object is read-only". I realize it...
How would you proceed with the attached file? Here´s the situation/problem:
SAP system is throwing lots of "unusable" txt files (the best one I could get is the attached one). Right now I...
I have a combo box which i threw together and I designated the control soure to my bound form but when i use the mouse wheel to sort throught the records it replaces the data in my fields to n...
Please help me identify the error in the attached snippet.
When I split the original DoCmd with a IF/ELSE, I get an error on the new (longer) line.
A "Enter Parameter" dialog pops up, asking...
How to click a button then pop up the dialog box, then allow to select a file and get this file path to textbox?
I'm running Microsoft Access 2003 and I'm trying open up a form based on the selection in a subform which is based off of a query. Ideally, when that record is selected(double clicked) I want...
trying to run these two strings but its not working
Dim varConsumeDate As String
Dim varChargeCodeID As Integer
sqlStrConsumeDate = "UPDATE [" & varTmpTableName1 & "] SET [Consumed...
In the Access database I inherited, there is a button that is supposed to email invoices to clients who provided us with email addresses. There is a VB code behind the button. Everything loo...
"User-Defined type not defined."
The text is highlighted at Dim Target As Range
/////////////////////////////////////////////////////////////////////////////////////////////////
Private...
Hi,
I would like to take a string such as "Hello World, Opps I just added 2 spaces after the comma" and replace it with "Hello+World,+Opps+I +just+added+2+spaces+after+the+comma"
The pr...
I am having trouble writing the code to set the combobox value on open.
The combobox has 2 columns from a query. the bound column is a short date field. the second column is a description o...
I have a form with a list box that populates from a query when the form opens. On the form, I have several controls (combo boxes, text boxes) to filter the list by several of the fields. I'm...
I have a form with cmd button and text field. User enters number in text field and on click of cmd button new invoice number is updated in first field of invoice table. That part works. How do...
Ever wondered if it can be done? It can.
The idea came one day where I wondered why SQL Server presents a time resolution of 3 ms while Access/VBA/JET only offers 1000 ms, both using the sa...
I have to periodically import text files in to an access table. I would like to have a browse button and be able to import the text file from where ever it is on my drive. I have a table and...
I would like to export Access 2003 parameter query to Excel with Data Autofilter and Window freeze panes. Hopefully someone will have an answer. Attached is the code snippet
I am trying to import a file from Excel into Access via a command button on a form. I keep getting the following error:
Run-time error '3274':
External table is not in the expected format.
...
I have over 300 tables in Access 2007 all with very similar names (table_1, table_2, table_3, etc.) and identify data structure (columns with the same labels and data types). I would like to w...
I have setup some queries in Access that will help me look at data in certain reports. However, I need to pull the data by each month for several years. I have a table in access with all the...
I'm using Access VBA to open an Word document (doc1), copy the entire words, and paste into another Word document (doc2). Then close doc1 and save doc2 into the local drive.
My problem is I...
I have a table with a date field, a field called "cate". In the "cate" field some records contain a number either 1,2,3,4 or are blank. I need to create a query that if the date field has a da...
