Basically I want to the query to split comma delimited values into separate columns in access query
example:
Apple 1,4,5,6
Apple 1 | 4 | 5 | 6
How would I do this?
I currently have an crosstab query containing several pcs of data. The Column heading is a date related to to some data being queried from outside Access (not relevant).
I am trying to wr...
How do I setup a combo box on a form in ms access2000 that will accept and store a list. I have tried several ways including the "ON Not in LIst" event. How do I get the event to work so I c...
Hi All,
I am working on a query in MS-Access Environment, where I have to search for a date [input from user] between two dates [stored in the table, "from_date" and "to_date"]. I am able to ...
Hi there,
An mdb file was lost due to hardware failure. Used Norton System Works 2002 to recover. Since then any attempt to open the db file displays the following error message:
"The Micros...
I am trying to covert the following text field 19970519 to a date field in Access 2003. This text field is in YYYYMMDD.
Simple question which I have done in the past yet cannot find help on how to do it. I know that I use a connect method, but cannot rememeber or find anywhere sample code to do this.
I need ...
Does any one know how to Delete a record in VBA Code..for Example...
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Wi...
I know this has been ask before, and I know the aswere was no...but has anybody developed a way to convert an mde back into an editable format. Free is good, however I'm willing to pay for a ...
Is there any way of writing a function that will calculate the no of working days between two dates, WITHOUT looping through each row.
I am currently using this ...
Public Function ...
Hi
I have a simple Access form with a button that creates a new record.
There is however no btton to save the entries made to the table.
What VBA code would I use to commit the data to th...
Kitty's Great Calendar Project gets its data from an Excel table the user generates outside of Access (ExcelCaledar).
Right now, I have the table ExcelCalendar linked to the CalendarProject...
Hi,
I would really appreciate it if somebody could run me through how to use Union Queries.
I'm totally new to union queries and don't have a clue where to start.
I would love it somebo...
I have a linked MySql table in my access database. The access database stores russian strings but it appears ok. I think it uses unicode to store them. However, the mysql database stores the d...
hi experts,
I am creating a table from C#, asp.net .This is my code:
DbOpen();
string strStatement = "CREATE TABLE MyNewName(PersonID COUNTER PRIMARY KEY, FirstN...
Hi
How do you NOT show the recordset as a result of this:
DoCmd.SetWarnings False
DoCmd.OpenQuery "qRev3a"
DoCmd.SetWarnings True
I do not want the table/recordset show up
...
Hi,
I'm trying to import a very large (50 thousand+ rows, 65+ columns) Excel spreadsheet into Access. I keep getting the "Numeric Field Overflow" error. Every field in the table that i'm im...
Do any of our experts know where I can get a database table with a list of all UK towns, cities, counties and postcodes for checking the missing information in my existing database.
Many th...
Hi Experts-- Lots of info on this subject but I can't seem to find an example that pertains to my situation. I have an Access 2003 application that uses a SQL Server 2005 DB backend. The Ac...
I have an Access form with several data stored in Labels. I would like to input the data contained within these labels into a target table called "target_table" within the same acccess dbase....
I need help with code sample to get the max(system_creation_date) where the acct_nbr in Tbale 1 = the acc_nbr in table 2. That data needs to be inserted into another table. Asingle row should ...
Access 2003 Saving Table as Access 2000. Dell Optiplex GX620 3GIG memory, 40GIG hard drive free.
Data normally has two text fields, two date fields and four other fields.
The first record ha...
I need some help dumping a recordset into a temporary table to be displayed in Access. Is this possible?
VBA code is used to perform a stored parameter query. The code is attached below.
Hello Sirs,
I get the following error message when I try to open an access database from a VB6.0 application running under windows 98
"Provider Cannot Be Found, It May Not Be Properly In...
How can I change the logo of the "Office Button" in Access 2007 instead of using the default MS Logo? I am using the USysRibbons table and have a complete XML custom ribbon. I added the <off...
