Insert Query Problem  

i m a newbie to MS access ... i have two tables 1) LabTest with Fields (Test Name: primary key and Rates ) 2) Patient Visit (Visit ID: primary key, Test Name, Rates)problem is ... when ever i change the ratesthe past... Continue Reading
Views : 93
Monday 22nd of October 2012

Filling form and emailing it  

I have a form that the user will fill, then email it to a customer.I dont want to send the whole table, just the values that the user just inserted in the form.Any idea on how should i do that using Access?I am aware of the SendObject method, but i... Continue Reading
Views : 102
Monday 22nd of October 2012

Anyone help with this one  

Just trying to learn,I have a selection box where I can choose country, after I select the country a table is created with 3 columns from the databaseI then want to post the record from column 1 to a processform.asp "which works fine" this column is called... Continue Reading
Views : 92
Monday 22nd of October 2012

Tracking Changes in Access 2003  

Hello,Can someone tell me how to set up a track changes in Access?Thanks,Kelly Continue Reading
Views : 44
Monday 22nd of October 2012

can't insert data into textbox  

why do i get all the weird problems?does anyone have any idea why a textbox would act like it was locked, even though it's not?anyway, the text box works fine, until i click my button which goes to a certain record based on my listbox. the code for the click... Continue Reading
Views : 106
Monday 22nd of October 2012

SAVE Dlookup value on form to TABLE  

I have created a frmOrder form that uses autofill fields using dlookup when a company name is selected from the cboCompany combobox.However!I noticed that the value that has beed retrieved from dlookup function are not stored in the table (tblOrder). Continue Reading
Views : 108
Monday 22nd of October 2012

how to create tool bar menue in access  

Hi guys. I want create a tool bar menue in access 2000 that is linked to indvidule forms in my access but i do not know how i to do it. Just like internet explorer tool bar menue that has file edit view ... and u can click and a drop down list comes and u can select one and... Continue Reading
Views : 283
Monday 22nd of October 2012

How to delete current record in bounded form  

Hi guys. I made bounded maintenance form customer table in my access db. But when I try to delete a record by clicking on the delete button I get the following error. I be happy if some one help me delete record successfully. Thanks Continue Reading
Views : 101
Monday 22nd of October 2012

parameterized macro  

I have a parameterized query to which date needs to be passed from a text box on the form. Also after running the query, the output of the query should be transfered to an Excel Sheet. Do I need to macro ? How can I achieve the result with a macro ? Or is there any other method... Continue Reading
Views : 58
Monday 22nd of October 2012

hardcoded parameters in querys--can I find all  

We have a tbldepartments. At this point (has been a few years)...many dept. have merged or changed names. We want to 'change' the names of some and delete or add others. Ok on the delete/add. However, in many of our queries, we have the dept. name/number... Continue Reading
Views : 392
Monday 22nd of October 2012

problem with this insert statment in vba  

problem with this insert statment in vbaHi guys i got vba code that suppose to write table name ,column name , rquired ,feild type and feild sizeto an external db. The first part of this code write tables naem to external db and it is working well.I get the... Continue Reading
Views : 84
Monday 22nd of October 2012

Combo box value reflecting in the text box.  

I have one combo box and a text field. When I select the Analyst name from the combo box I want to display its corresponding Badge Id in the text field. Both the Analyst name and the Badge Id are in the same table.Please help me out with it. Continue Reading
Views : 143
Monday 22nd of October 2012

Reporting in Excel  

Hi,I have an issue with reporting in Excel. A table has a Fax Id field which holds unique Fax Ids. The ID is a unique number given to a fax received. The fax is processed by an employee and the table stores the employee id and fax id processed by him. I have a query... Continue Reading
Views : 46
Monday 22nd of October 2012

Run-Time error '3134'  

This is my code for the insert into command.I can't seem to figure whats wrong.DoCmd.SetWarnings False If Not IsNull(Text96) Then DoCmd.RunSQL "INSERT INTO walkers (Walker, Firstname, Lastname, Date, Visits) VALUES('" & Text96 & "', '" &... Continue Reading
Views : 68
Monday 22nd of October 2012

Access 2003 Warnings  

Hello allI just installed ofice 2003 and always get a warning message that some codes in my database might harm my aplication. SECURITY WARNING: USAFE EXRESSIONS ARE NOT BLOCKED" SAYING MICROSOT JET 4.0 SERVICE ARK OR LATER MUST BE INSTALLED. How... Continue Reading
Views : 73
Monday 22nd of October 2012

Month and Date only field  

Is there a way to create a field (Table or Query) that contains the Month and Date only and not the year? Continue Reading
Views : 117
Monday 22nd of October 2012

how can i join these tables  

there must be a way to do this, but i haven't been able to figure it out yet...table one has three fields i need to be concerned with, member_ID, range_start, and range_end. no part of any range spanning range_start through range_end will be duplicated. Continue Reading
Views : 86
Monday 22nd of October 2012

Still working on a count problem  

I have a report that is to count the number of times a field has been selected.Some of my fields are in option boxes, some are individual boxes. The option boxes do not add up. On my report I get an *error* on all the option box totals. If I request a record from a... Continue Reading
Views : 65
Monday 22nd of October 2012

Format of photos before inserting  

After doing lots of reading and research re inserting pictures into my database, i think the best way is to go with the bound OLE field which is linked to a picture. My only problem is that my photos are JPEG and when i try and link them i don't get the image just "Package". ... Continue Reading
Views : 74
Monday 22nd of October 2012

Updating a table in Access using VB  

I have a form that updates a table. It's got some convaluted logic (I didn't write it I swear ). I am trying to add some Continue Reading
Views : 70
Monday 22nd of October 2012

Need Help ..  

Hello guys,New to access 2000,I have one issue,I have form with the button and when user clicks the button following thing should have :Got one table tab1 which has col1 which holds the sql query(code) "select acol,bcol,ccol from role;"so when u say... Continue Reading
Views : 62
Monday 22nd of October 2012

How to calculate cumulative values of this query fields  

Hi everybody. I got a access 2000 query that lists :1)weekno2)year3)project (project number )4)QweekylyReportHeader (project description )5)customer (customer that requested this project)6)department ... Continue Reading
Views : 388
Monday 22nd of October 2012

need help using the split function in mdb  

First, my knowledge is limited so please forgive me. The problem I have is a persons full name in a column and I wish to have first name in a column and last name in a column. ex: John PublicI would like it to be JohnPublicthanks in... Continue Reading
Views : 94
Monday 22nd of October 2012

Is this possible  

Is it possible to change the attributes of the text of a field on a form (e.g. the color of the font used) based on the contents of another field shown on the form? I have a database application that I would like to be able to change the font color of a field if the contents of... Continue Reading
Views : 74
Monday 22nd of October 2012

Problem with Access Report  

I do a report in ACCESS 2000. In the footer of the report I have 3 fields and the number that appears in each one is calculated in the code of the report. When I preview the report all the numbers are correct, but when I print the report all the numbers in those fields are... Continue Reading
Views : 72
Monday 22nd of October 2012

How to build a funciton to return primary key,alternate key and foreign key fields  

Hi every body. I need to create a function to return a string containing :A) primary key fields together with primary key names . B)alternate key fields together with correspondingly alternate key names.c)foreign key fields together with correspondingly... Continue Reading
Views : 186
Monday 22nd of October 2012

Hiding the menu bar  

I have created a custom toolbar but the default (access) menu bar still appears every time I open the database. I can uncheck it under toolbars but this doesn't hold on re-opening. How do I do it? Continue Reading
Views : 72
Monday 22nd of October 2012

LIMIT Query Problems  

strSQL = "SELECT * FROM Table1 WHERE expire_date>#" & dteDate & "# ORDER BY post_date DESC LIMIT 3;"If I take the LIMIT part off, it works, but add it on and it causes:Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC... Continue Reading
Views : 105
Monday 22nd of October 2012

Can't Import Excel file into Access  

OK. I feel like an idiot but I did read the manual, Googled, and Microsoft help, but still cannot do it.The problem is on the import feature, there is no option... Continue Reading
Views : 79
Monday 22nd of October 2012

Making Chart from a Query  

One of the requirements of my project is that a report should print a Bar Chart, based on a query.The related query has the following fields:ItemCode, Quantity_received, Quantity_delivered, and the Date.The report should depict the number of... Continue Reading
Views : 78
Monday 22nd of October 2012