Hi All,
I am trying to upgrade an Access 2000 DB to 2007 (using linked tables and ODBC to connect to backend SQL 2000 database). In my DB, I have a mainswitch board and some command buttons on it. When I click the command button it should open another form to show some records.
My problem is that some of the buttons work fine but some others just stuck there and then poping out an error message asking me to manually...
Jiwei06xie
Last Activity: Dec 22 '09, 01:05 PM
Joined: Sep 1 '06
Location:
-
Problem with upgrading Access 2000 to 2007
-
Hi I have sorted out the problem. Where am I wrong is that I need to add the main form (i.e. the form holding the tabcontrol pages) into the filter condition when moving into a tabcontrol, like: forms!tabcotrol form!mfrmcustom er!tarketmeterI D.
Cheers. -
Combobox not working properly when moved to a tabcontrol page
Hi,
I have a main form with 3 subforms and some combo boxes. It is working fine as an independent form. However, when I draged into a tabcontrol page, two off the combo boxes stopped working properly. The filtering criteria I used stopped functioning. Here are some details about my problem:
(1) the following 1 main form and 3 off subforms are all in one-to-many relationships.
Main form: mfrmCustomer
Subform1:... -
Jiwei06xie started a topic tracking monthly utility bills: monthly charges, units/volumes, costs per unit, etc.in Accesstracking monthly utility bills: monthly charges, units/volumes, costs per unit, etc.
I'm interested in tracking monthly utility bills....monthl y charges, units/volumes, costs per unit and so on, by monthly date. The data source would be mainly from an Excel Spreadsheet (or sometimes SQL database). Are there any sample projects out there that I might be able to adapt to what I'm interested in?
How would I chart the data, so I could see trends (i.e., cost per volume, etc.)
I'd be most appreciative if anyone... -
Many thanks for your kind help
Thank you so much ADezii & Puppydogbuddy for your suggestion and link.
I have just managed to figure out my problem. The valid SQL database was stored in a "secret" different folder! Anyway, do appreciate your help.
Have a nice day.Leave a comment:
-
Attach back mdb database
Dear All,
Urgent help needed.
I got an Access database as frontend and SQL as backend. This afternoon I tried to copy the backend to another server. Following some suggestion, I detached my database from Enterprise Manager. The problem is that I can not attach back my database anymore. The error message is "the file you'v specified is not a valid SQL database".
One more thing I noticed is that... -
It's a magic. Working perfect with my case.
Thank you very much Dezii.
Regards, Jiwei...Leave a comment:
-
Thank you very much Stewart for your reply.
I will have a try later today.
Kindest regards, Jiwei...Leave a comment:
-
Filtering records with question mark at the end
Can anyone help with filtering records ended with "?".
here is the code I have tried:
Not working at all. Any help is appreciated.Code:strWhere = strWhere & "([stock_site] not like ""*" & "'?'"") AND " strWhere = strWhere & "([goods_status] not Like ""*" & "scrap" & "*"") AND "
-
I have found the answer. Nothing wrong with my code, it is the primary keys of the two tables in SQL. By creating two similar tables, I have managed to get everything back to normal. Many thanks anyway.
Jay...Leave a comment:
-
Hi ADezii,
I have added the code something like:
rst.update
rst.requery
rst.close
but I got another similar error message after waiting for about 1 minutes, "run-time error '-2147467259(8000 4005)' ODBC-call failed". Without that code, no problem in adding a new delivery record.
Any further help? Many thanks.
Regards, Jay...Leave a comment:
-
Dear ADezii
Thank you very much for your reply.
(1) I am sorry for confusing you by the rst3. It is used to copy field "deliveryNo " in tblDelivery into the second tblDeliveryItem , which is the link between two tables. Some key fields in the two tables are:
tblDelivery
delivery_ID (Autonumber)
delivery_No (text)
deliveryDestina tion_ID (number)
DeliveryDestina tion...Leave a comment:
-
rst.update: run-time error -2147217887(80040e21), ODBC-call failed
Dear Expert,
Im using SQL server (2000) as my backend and MS Access (2000) as F.E..
I use two data entry froms to add new records, form1 to enter details of delivery (tbldelivery) and form2 to enter details of delivery items (tbldeliveryite m). Previously everything is fine, but about 2 weeks ago an error message keeps popping out "run-time error -2147217887(8004 0e21), ODBC -call failed" after I add one delivery... -
Dear Rabbit,
Many thanks for your reply.
Do you mean I can create a new moduel, copy and paste the codes into the created moduel, and then call the function when it is needed? please pardon me if I ask a stupid question as I am quite new with Access. Would you mind to give me a quick sample?
Looking forward to hearing from you.
Kindest regards,
Jay...Leave a comment:
-
Help: change active connection from one form to another
Dear expert,
I got two forms.
form1: Combox form Form_rptStock (key field: serial number), with one command button.
form2: Entryform Entryform_stock , with a series of command buttons. I use this form to add new record or edit/delete a record. (it works perfect independently)
What I am trying to do is when I select a serial number from the dropdown and click the command button cmdEdit in the 1st... -
Thank you Scott for your reply.
I did manage to write a query to find what I want, but failed to insert into the 2nd table with error message like "it didn't add 1 record to the table due to key violation".
What I did is to create a form, where I can type in serialnumber, and a command button. When I give a serialnumber and click the command button, it should run the follwoing query:
[CODE=sql]Insert...Leave a comment:
-
Find and copy record from one table to another in Access 2000
Dear Experts,
As I am a beginner of Access 2000, could I ask for some help regarding the following situation?
I have two tables called tblDelivery and tblStock, both having a text field SerialNumber. What I am trying to do is to search in tblStock using SerialNumber to see if there is a matching record. if so, I need to cope some relevant fields to tblDelivery, and then delete that record from tblStock.
If no...
No activity results to display
Leave a comment: