Getting Started
in [Access]
|
I receive an error message Type mismatch Who can help me??? I would appreciate this. I'm trying to do a check on a table see below. But I get a Type mismatch error on the And "[Primary contact]= true" Can someone help me with this? the collum is a field where I reffer to. Private Sub Command68_Click() On Error GoTo Err_Command68_Click Dim st... 2 Jul 2008 07:47
Price Update I have a Work Order Database where my tbleequippricelist needs to be updated to new pricing. When I change the pricing all of my history invoices change. What is the easist way to update these prices. I have tried an update query but I made a big mess. tbleequippricelist ID- autonumber PK description - t... 1 Jul 2008 16:27
simplest way to enable macros in Access 2007 My office recently upgraded to Office 2007, and now we have to enable the macros every single time we open up the database in order for our search boxes to function. What can I do for Access to trust the macros in our company database? (without having to go around and make it a trusted source on every single ... 1 Jul 2008 13:22
Access 2002 help please ! Ok so I volunteered (silly me) to create the customer database thinking it would be easy! I have used a basic MS template and manipulated it to suit my needs. I now need to put in a search button for companies, people and post codes . I also need to create reports such as call visits, contact listings and comp... 1 Jul 2008 19:32
Setting up of a training database Hi I am new to access. I need to set up a training database for the company. I need to have info in there on type of training,training provider, duration, cost ect. Is there a template I can use if not how do I start this database. I must also be able to draw monthly stats so we can see how many employees ... 4 Jul 2008 19:13
Inserting into an AccessDB from Excel worksheet Hi, I'm new to Access and kinda new to Excel as well. Anyway, I got a new summerjob, and they've asked me to make sort of a database system, which they can use to store some of the information they insert into different Excel sheets. I've tried to link the Excel sheets to Access and using the Get External Da... 1 Jul 2008 05:09
copy records from a table in one file to a table in another file How do I copy records from a table in one file to a table in another file. Every time I try to do it message "cannot do it because Table is in use by another user". Please advise as if you are talking to an idiot - thanks ... 2 Jul 2008 03:42
Display similar information from 2 tables in one query I know I'm overlooking something stupid and simple. I have 2 tables with similiar data, that need to be kept seperate. However, in one SINGLE instance I need to display all the similar fields together. I really want it to be a query, but I'll live with a report or something. How do I do this? ... 30 Jun 2008 23:01
Making it stay the right size I'm working on making my form nice and pretty, and I'm trying to size it appropriately. I've got it sized how I like in design view, the autoresize is turned off and even in its properties its set to the size I want. Yet, when I save and open it the size doesn't change!!!!!! Also, is there a way I can set it ... 30 Jun 2008 15:49
Combo box and table relationships doesn't work as expected I have 3 tables tblClient tbClientSchedule tblClientPlan ClientID ClientScheduleID ClientPlansID Client Name ClientID ClientID Address DueDate Plan ... 1 Jul 2008 18:31 |