I am trying to import an Excel spreadsheet into an Access table, but I can't seem to get things to line up correctly. My Access table has columns id (the primary key), client, date, start_time...
I have been working on a database for my job and have been told to get it completed post-haste (no pressure here!). I need to be able to automatically create a job number for a job based on th...
I have a DB that sends custom text messages to people. One of the tables is tblTextMessages. Stored within the table is a field, fldCustomEmail, which records who the text messages were sent t...
MS Access 2000
How would I take a table with a list of 30 or 40 lines (lastname, firstname) and add a randomly generated password to another column in the table based on those two fields, a...
I have more than 180,000 rows of data stored in a csv file and/or Access database. Each row has 10 data points that I want to plot in a line chart. Right now I copy and paste from EditPlus t...
Hi Folks,
I Have a database with a table called rss and a field called text.
What I want to do is go to rss link (http://feeds.engadget.com/weblogsinc/engadget) copy all the text from th...
How can I open a query in design mode from code? Menu items can be accessed from code using CommandBars eg
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). ...
What is the easiest method to make an Access 2007 database searchable through any keyword through all tables, etc. Is it possible to setup a keyword search to search the entire database? If ...
HI
As you can see in the following question:
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_23541110.html
I have installed access 2000, 2003 and th...
Hi Experts,
I am new to access.
In a subform i have a cell with a lookup from a list of colours.
once I have selected a colour is there a way to default the next row's value to the on...
The following statements works just fine if I run it in a SQL window within MS Access....
update patents set fullname = [LastName]&", "&[FirstName]
But when I insert it into my module I ...
I've tried to create a new project using the MFC Wizzard and I get to the point of selecting database view with files. I select ODBC and Dynset and there's a button for "Data Source". I don't ...
What is the simplest way to prevent a user to not exit from the application. I normally use ascii code for key presses .... thank you.
I am using
MsgBox AccessError(DataErr)
in an OnError event procedure. However, I'm finding that AccessError(DataErr) always a zero length string.
I've tried DataErr = 3314 and 2113.
How do I get the export wizard to open when I export from a Microsoft Access Database Project?
In an Access form with
txtSentOn and txtSentBy data at hand, open the matching email in Outlook.
Could be this done?
Thank you.
I have very simple setup with huge number of records. What I have is mysql database ass backend and ms access as fromt end. Then the Tabale1 is linked into ms access database from mysql. I mad...
I have two tables as follows:
BillingHistory
GuarantorID StatementDate AccountBalance
000134 05/05/2008 110.00
000134 03/10/2008 ...
The following snippet is the OnClick event procedure for a command button on a form. Problem is, the change to the Rev field is maintained even after it is rolled back. Why is this not working...
Hi,
I have a form that has a memo box on it (mmText). Access 2003 Database.
In order to "search" in the box, I can press Ctrl+f and type a word, and have access search that field for the...
I have a database that when I open a table and right click on the field to filter the results, the option "Filter For:" prompt is no longer showing. Never seen this happen before, so I suspect...
Hello Experts:
I'm creating an audit report to reflect "what changed" between one week and the next for certain fields on the database. To do this, I write to a "what changed" table, and cap...
In Access 2007 I created a form that references a table that has a bitmap field. When i copy a bitmap and paste it in the form in form view I can see the picture but the form freezes and I hav...
We scan barcodes into an Access 2003 database for cataloging purposes. Our supplier has changed the barcode types and now whenever an attempt is made to scan a barcode the error message "The V...
I have an access report that needs to use the following:
Public FTE08 As Integer
Public FactorFTE As Integer
-------------------------
Public Function GetFTEFactor() As Integer
GetFTE...
