i have a table with a date field with default value for new records date()
when i change an other field and im going to save the changes access says that canntot save the changes because of unknown type date()....
I have three tables: Vehicles; Vehicle Reallocated; and Vehicles Retired. I have a form that runs a query to find all the info in the Vehicles tbl that is not "Retired", not visible in the form. I then have the option to toggle to a Reallocated or Retired form. When i toggle to the reallocated form, i have the like fields in that table (ie Van #, Vin, Make etc) pulling the info from the hidden subform with the vehicle query, so i do not need to fill in repeat data. However, when i add a reallocated date and the new clinic that vehicle is for, i get the record ID for the vehicle reallocated table as expected, but when i save none of the data moved over from the query saves in the record?
How to get all the data on the reallocated form to save?
Is it somehow possible to save a table's width while in table view in A2003? I tried several things and can't find it on the internet.
View 10 Replies View RelatedSo I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.
I am using Access 2010.
I have a few selected reports on an Access 2007 database that users can run. Is there a way for users to view the report, save as a PDF and automatically save a copy to a shared drive by modules/vba coding as an On Click event procedure?
View 4 Replies View RelatedOkay, I've been working on this database for weeks now, I'm almost done, there is a light at the end of the tunnel and my boss is anxious to implement the db as I'm only here for 3 more weeks and it MUST be completed, tested, error checked before I leave. So I'm running out of time FAST!
Okay, the problem is simple. I'm using a Data Access Page in Access to build a nice little front-end for my database for my co-workers to use. On this DAP (Data access page) I have an Input box that allows the users to browse their directory and select a file. I need to take the path/file name that pops up in the input box and just save it to the table. I can take care of all the other elements.
So, through DAP, how do I save the value in the inputbox into my table. Please, any help would be great! :eek:
Hi Guys,
What i am trying to do is, i have two tables called Table1 and Table2.
I have created a form called Form1.
This Form1 has all the fields from Table1.
What i want to do is, as soon as a user fills in the details in Form1, obviuosly it saves those details in Table1, BUT i want it to save a couple of field values into Table2 as well.
How do i go about doing this??
In Table1 i can access the fields by "Me.[Fieldname]" (from the VB script), but how do i access Table2 OR how do i save data to Table2 from Form1.
Thanks
Hi there...
I have a table which contains a field with the name "date". i have defined the property "date/time" on the data type of this field and as an input mask I have: “99/99/0000;0;_” i want the date to be saved as 02/02/2008 but every time I try to save it the zero digits are deleted and it is saved as 2/2/2008. How can I do that??
I have in my Form.
Table 1: Vender Name, Number, contract, amount, quantity,and order number.
Table 2: Doc #, Date. Multiple Doc #'s and dates will be saved under one vendor name (hence the two tables).
What I need is a MACRO where once I save the Doc #and Date to a record, I need to be able to go back to that record and enter a new Doc # without saving over the one I originally did.
I have a table with 140 fields (I know, this is too many). I have a date field that intermittently will not allow data to be entered. There is a pattern to the data it will not accept, but it seems to only occur in certain records and what it will or will not allow seems different in each case. The error I get when I try to save a record is: The search key was not found in any record. I've isolated the error to the level of the table. Have tried compact/repair, removing the index on the field, deleting and recreating the field. Nothing works. Help! :confused:
View 5 Replies View RelatedDoes anyone know if its possible to save screen prints in a table?
View 3 Replies View RelatedI want to save an Access query result to a Table, but I couldn't find a way. The only thing I can do is save the result to excel or as a query in another file. Any hints? Thank you very much.
View 2 Replies View RelatedI 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).
How can I achieve this?
I have written the code in the control source of the field (in this case: LastName field) in the form like this:
=DLookUp("[LNamePIC]","tblCompany","CompanyID=" & [cboCompany])
The DLookup works fine, just I want the value to be stored in the table. Please help me ! I have been browsing the internet for the whole day and i can't seem to find the right solution!
Thanks!
Warehouse inventory system in access 2003. I have set up two primary tbls: Equipment and ETO (Equipment transfer order) both have an autofill primary key and the equipmentID is part of the ETO tble. There is a one-to many realationship from the equipment to the ETO. There are other tables (4) in the system but they are used as look-up tables and i'm not concerned about those.
Equipment Table layout: EquipmentID, ModelNumber, SerialNumber, Mfg, ProductName, CurrentLocation, Category. This table is used as the repository for all of the equipment that needs to be tracked and inventoried. It will not change much with except the CurrentLocation changing as the stuff is shipped around (in Store, In Warehouse) and of course when new equipment is being added.
ETO table layout: ETOID, ETONumber, FromStore, ToStore, OriginStore, ETODate, ModelNumber, SerialNumber, MfgID, ProductName, LocationID, CategoryID, EquipmentID. This table will be used (I hope) to basicly track the equipment as it moves from store to store to warehouse and back out again.
Process: Locate a peice of equipment by either SerialNumber or ModelNumber in the Equipment Table, change the location depending on it's status (coming in, going out) then i need to somehow update the ETO table with that ModelNumber, SerialNumber, Mfg, category, etc..But put in the FromStore, Tostore, OriginStore, ETODate, etc..
I have tried both the update query and append query from both tables but I can't get the results i need.
We import data to a table on a weekly basis. We delete the table and replace the data. Most of the data is the same. It's date's, group names, ...
Now we would like to save the weekly table and add a saved date. Then we would like a query that puts all the saved tables together and that we could filter.
For example. A team is planned to do a work on 01/01/13. The next week it has changed to 07/01/13. So the data in the table it updated but we can't track the changed date. If we had the different tables we could filter that team and so that the work was originaly planned on date x to be done on the 01/01/13, on date y it was 07/01/13....
Of course if we would save the complete table every time it would mean a lot of useless data that hasn't changed. So a better solution would be that a query could see which data has changed and it only saved those lines on that date.
There is a public master database with a bunch of tables and data in it being maintained by another group. My boss wants to skim some information from this, add some of his own information to it, and save it in a completely separate .mdb file on our server.
I've used Access to link to the public database, built a custom table just for us, and built a form. The form uses bound controls on the left side to pull in data from the public database, and unbound controls on the right side for user entry of data. I coded a VBA save button that should save all controls (bound/imported as well as unbound/data entry) to our local table.
The unbound controls save just fine, but the bound controls are missing from the table. A new row is created with no problems, I get no error messages, but half the fields in the table are just blank.
Code:
DoCmd.GoToRecord , , acNewRec
Dim Rs As Recordset
'Dim SDB As Recordset
'Dim strSQL As String
Set Rs = CurrentDb.OpenRecordset("Supervisor Table", dbOpenDynaset)
[Code] .....
table A has 10 records where 1 field is set as REQUIRED/UNIQUE. the table B does not have any record but have a same field like table A. what I want is that if user insert the record in table B it should first check whether record is already present in table A or not, if already exists it should not accept insertion. and if not already there in table A it should insert record in table B.
View 3 Replies View RelatedDoes this sound like a corruption problem?
I added a new field to a table, and saved the table. When the table is reopened, the new field is not there! I thought perhaps I forgot to save the field, so I tried adding the field again. When saving, the error said, "cannot save; duplicate field name".
If I go to toolsoptions and click the "show system objects" the field will show up??
Do you think the best course of action is to import all the objects into a new db and try again?
Thanks for your help.
Mary
Hello!
I am trying to update the current status of an asset, when it was returned or checked out. At the same time, save the changes in a history table to record all the changes in past. I can do individually from different tables and different forms, but I would like to do from one form and one record entry. Is it possible? If so can anybody help?
Thanks
JVirk
Hi there,
I am about to start working on a new project where I have a front-end in Access2000 that is linked to a ODBC Data Source (ORACLE).
There could be some performance issues in the future, when the users have to retrieve (query) the data from the ODBC over the network and it slows down. Nothing is sure yet, but when this is the problem, I will need to look at an alternative plan. I had the following in mind:
I would like to create a scheduler program, that will retrieve all the relevant data from the ODBC and update the tables that are local to each user’s Access .mdb file. Can I do something like this in VBA, or do I need to do something with the Windows Scheduler?
Any tips are welcome, thanks in advance
J
Hi there,
I've read through the forums on saving the results of a calculation into a field is a bad idea. I somewhat understand the reasoning for it. But I don't think such situations arise for everyone.
But I have gone with the suggestion and created an updatequery, which simply goes through and updates the calculated value into a table. Now each time the updatequery is run its asking for permission as to the fact if I'm sure I want it to be run. How do I turn this option off. And should I call this updatequery afterupdate or beforeupdate?
Thanks
I have a form which calculates alot of numbers. Im trying to figure out how to save the calculation to a table field. Is this possible? Can someone help me with a solution please
View 2 Replies View Related1. I have a Main form (based on a table) with a Subform.
2. The Subform is based on a Query
I want to save the data from the Subform (Salary Field) to my Table, I dont know if VBA will be the best option.
TABLE FIELDS:
ID*
EMPLOYEE_NOS
NAME
SALARY
MAIN FORM FIELDS:
ID*
EMPLOYEE_NOS
NAME
SUBFORM FIELDS:
EMPLOYEE_NOS
SALARY
code to save data in listbox to a table in vba access
View 2 Replies View Relatedi got a form with three normal fields where i add data i then have two auto number fields i.e. SupplierID and PersonID the supplierID works fine, i can add a new record and click save and it will save the data in the suppliers table.The problem is with my PersonID field, i need it to retrieve the data from my subform and firstly display in the field on my main form and secondly, when i click save it should save save the number that is displayed into my Suppliers table.
View 2 Replies View RelatedI have a query that I dump into a table...via Macro. I made changes in the table (User Input in some fields) ..can I requery and not overwrite the inputs? I am new to Access not sure if this is possible?
View 4 Replies View Related