Hi all!
I was wondering if you guys can help me out with this one:
I would like to have data auto-inserted from a particular colum in table 'x' in to a defined column in table 'y'. similary, I'd like to achieve auto-updation of this data as well as deletion. Can anyone please provide some guidelines?
A little more detail :
I have a column "Client ID" in the table client_personal_info, the rows of which I'd like to have updated in the "Client ID" column in the client_business_detail table.
So if say, ClientID_1 is a row that has been added by the user, I'd like to have it auto-inserted in the client ID column in the client_business_detail table
I have written a form from a table which holds employees details. This table has a photo field. The form has a control which displays the employee’s photo. It uses the field, photo as the control source. This works okay but if you wish to enter a photo from the form you have to click on insert. Browse for the file etc. The Sample database “Northwind” on the access help has a similar form, but under the photograph there are command buttons to add/change or remove the photo which is obviously a much more professional way of doing it. I have looked at the properties of these control buttons and they seem to work through a visual basic program. As someone who has a very limited knowledge of VB is there a simpler way of doing this or would I be able to cut and paste the code to work on my form somehow (If Legal) Any advice would be greatly appreciated.
I want wage rate should be inserted automatically instead of manually in attendance sheet. In labourwage form, wage rate will be fixed for labour type with wagedate as and when required. Once I add attendate in attendform, it should look-up the table labourwage and auto insert wage rate entry in to wagerate column for the respective month ie from the given wage date up to next given wage date of labourwage. I have tried much, but not succeeded and presently entering manually which is time wasting. This should be possible with writing some code with VB.
Someone once posted an database on how to do this but I was not able to see how they were able to automatically input the data into a text field.
I know how to do a combo box to query and input those results into a combo box but I am confused how they got the information from the combo box selection to automatically put the other variables into the testbox. They did this without using the dlookup command. In fact it was done without any code.
They showed how to do this automatically without code and with two other methods (one being dlookup). Can someone please help me if it is clearcut as I don't have too much time to search the forums for empty answers (believe me I have already wasted too much time) Thank You
On my form have a status field with about 7 options to choose from a combo box, i have these values set in another table. What i would like is for my other field, which is a date, to automatically change whenever the status field is changed. So i know how long ago the status field was set. So basically if i change the status to complete i want the date to then set the date and time now.
we use access database for printing lab reports. and a small graph is also printed on this report from another software(not an access application).
what i have done is that first we print the txt report from access and then use the same paper to print graph on it. I have alligned the report in such a way that these two reports fit perfectly.
we have to print twice and sometimes the graph is deleted in the other application, so we have to make the graph again.
what i want to do is: 1) prepare graph in the other application. 2) take a screenshot of it. 3) save this as an image file (jpg or bmp) 4) reference this picture in the access application and print it with the report.
So the problems are: 1) when i take a screenshot, how do i save it as a file, 2) how do i just get the area of the graph and remove all extra space. (usually all the other space is white as background)
If am a developing the db and just making alterations to forms and reports etc on a developing copy. Is there anyway i can auto pull and replace the ones in the live db rather than going into the live db, deleting all the forms etc and then importing it?? can it be scripted or somethign like that?
Hi...Im working with this database..its an order tracking database.. everytime we received the shipments we have to update the rcvd items.. i have an attachment here... pls i really need help...
How could i do these automated:
1: if i update the Rcvd status (Y/N) "Y" ...how could i make the Date Rcvd automated.. coz what happens is that.. i have to put date in each items that we rcvd and its a waste of time.. what if.. i have lots of rcvd items..
2. how could i put row count.. so i could know how many items i have and on what row are they...
I have a form I need to enter basic info into, and would like to know Iif there is a way based on the primary key id when I enter info on an individual's account, the rest of the info will get updated, i.e. contact info, full name, etc.?
Could someone please shed some light on any methods on a way to update fields automatically in different tables but with the same field name when data is entered into one of the fields in any table?
Sory about my english.I have a table that records data.Name-Surname-adress-payment time etc.The payment time is very important because all event is progress around this.Is that possible to remind me before the payment time?Thank you very much for your help.
I am building this little project for work, and came up with this problem. It's basically a database of the works in the workshop. Each car comes in, the service advisor adds a new job in to the database. And at the other end of the workshop, ppl can see it on the screen.
What I have managed to do now is that if someone modified any details of the existing jobs, it will be automatically updated on the other computer.
(ie, computer 2 has a form opened and showing all the current records in a continuous form view, computer 1 modified 1 record, then a couple seconds later, the form will update itself with the new data on computer 2)
The problem now is, if computer 1 ADDs a new record, it will not show up/auto update on computer 2's form, until I close the form and reopen it again.
Now I have no knowledge in VB and have no idea on how it work together with Access. I do however has some skills in other programming language like Java and C, so learning shouldn't be a problem if that has to be done through VB.
I have a database with a Source Table related to a Product table in a Master/Child relationship. The source table has a SourceID field as the primary key and a SourceName field. The Product table has a SourceID field as a foreign key and is related in a many to one relationship to the Source table (the source table is the one and the Product table is the many). I have a form used to update the Product table. The form includes Combo Box controls for both the SourceName field (which fills in a Source field in the Source field in the Product table) from the Source table and the SourceID field from the Source table (which fills in the SourceID field in the Product table). I need to know how to automatically fill in the SourceID control based on the selection made in the SourceName control. I would also like to know how to automatically open a form to update the Source table if I enter a SourceName in the Product.SourceName Combo Box that isn't already in the Source table.
If you can help me, please send your replies to james.ballotti@gmail.com
i have a complete access database with forms and queries and reports.
the only problem i am facing is that when i create a new report it only takes the data already entered.
if i modify or change a record in the form or table the report doesn't update the modifed data it stays as it is before and i have to re-create a new report.
is there any way to deal with this and make the same report auto refresh the data modified or no ?
I have added this to my database but dont see how it would be used. I have a shortcut people use to access the database which ties in my workgroup file infomation so that they can open it.
Now when I send the MDE file to people they get the "dont have permission" typical response.
Now if people are goin to use the shortcut to the either my .mdb or .mde then couldnt I just make adjustments to those and then replace the file on the shared network?
Am I missing something or not seeing how this would be useful or needed?
I was looking at Bob Larson's utility posted here (http://www.access-programmers.co.uk/forums/showthread.php?t=111132) and I have a question. Maybe I'm being dense (I probably am) but the loading page on my form looks like this:
Hi after I searched the forum for a solution similar to my problem I did not find anything that worked.
I have a form that it is used for hiring DVDs.
There are fields among others like customer_id, copy_id and a hired field wich is true or false.
I also have a submit button which saves the record before you finish. I would like to make the hired field for this record updated to value "true" when I click the submit button.
But, unfortunately doesn't seem to be working for me.
I added the equivalant field to 'Hired' after I had previously made tables etc and started added code to forms etc.
When I type Me. a list of options available to type in appear, and 'Confirm' (my equivalant to Hired) does not appear, yet all of the other field names in the form associated to this table DO appear. Does anyone know how to get around this?
I've also set my field to be "Yes/No" - does this mean that the code is:
Hi. I am new in using Access, so forgive me if the solution for my problem is easy.
I wrote for customers a little program, which receives data via RS-232 serial port and then place readed data into MS Access database. After i put the data into field in table (database, table and field are set in my program), there is some kind of script that continue the process of data manipulation.
The problem is, that customers want to activate that script automatically, when i place data in the field. So, i made a form, which contains bound control to this field. Every 2 seconds i am refreshing this form, so when i change the data in the table field, i can see the change in the form control. Now, how can i make the OnChange event to work, when the data changes? I tried to do it, but nothing happens, except if i am writing from the keyboard something directly in the form.
Can this be done and if, how must i do it, so when a new data arrives to run automatically the client script?
i have set up a database to help track the vehicles my company owns. However on the form i have created when i type in the license plate number want the work area that is responsible for the vehicle to pop up so i can inspect it.the form also has the different things i would look at but i don't want to continue to change the work area that has the possession of the vehicle or have to look it up every time i have an inspection come due. Any help would be appreciated
Is it possible to automatically update a date field in a form record without ever clicking in to that date field, but only because you have altered something else on that individual form record or an embedded, linked subform record? eg1. Staff details record - a) create a record for Bob Smith and 'Last Updated' field automatically inserts date b) amend record to say 'Robert Smith' and 'Last Updated' field changes to show new date, even though you never touched that date field. eg2. Risk register - main form record contains name, details, and 'Last Updated'; embedded subform allows you to add individual records of actions taken for each risk. I want the 'Last Updated' field to update each time I add an action, without amending the 'parent' risk record.
We keep a backend and a master frontend of a database on a network drive and distributed a .mde version of the frontend to the users who save a copy of it on their hard drive. There is a separate version table on the frontend and backend of the database for version comparsion. Whenever there is change on the master frontend, I shall change the version # on those tables and make a new .mde file on the network.
When user open their own mde frontend, there are scripts to check its version with the master frontend on the network and any mismatch will trigger off the following scripts (on the default form) to replace the old version with a new one from the network.
Private Sub Form_Load() Dim strFEMaster As String Dim strFE As String Dim strMasterLocation As String Dim strFilePath As String ' looks up the version of the front-end as listed in the backend
[code]....
This process works fine for everyone in Access 2010. However, these scripts appear to have conflicts with Win 7 when users upgraded to the O/S. They keep getting database unstable error message and the process fails to work. Whether we can change the scripts to make them compatible with Win 7?
