Search results

I have improved on a database I currently use for work, but I have run into problems now with the schema. When I would be designing a database I could not change or delete certain fields because of the relationships between two tables. I deleted these relationships but now my schema I feel is...

The issue is that I have one database that is entended to be the master database but I also need to use it in the field but when I get it back I need to have the data I entered uploaded into the master database. Is there a program or something I can do that would be able to do this? We have...

Thanks un binding the Combo Box Worked

Im wanting to know how to stop a combo box from changing the value of the first record in the field every time I type in something different in the field. Or how do you get the value of the combo box to revert to nothing everytime you close the form instead of replacing the value of the first...

I am designing a query that takes a string and numeric field from two different tables then finds the difference between the two numeric fields. In the string fields I have the criteria which is the same for both tables. The problem I am having is when either the criteria is not met it crashes...

I am trying to get a total difference after taking a difference between two fields. The expression have a specific syntax and after excuting i'd like to be able to sum the number I recieve in each record then get the total difference. Me Expression is: Expr1: IIf([Cleaned_Wt_grams]-[Grams...

I want to design a query that will be use two different tables with the same criteria (the lot number) to filter for the corresponding weight. In one table this lot number is specific to only one record whereas in the other table there could be multiple records with the same lot number. Ill also...

Thanks Isskint that should work but here is another problem. This query that I will be using will be querying from two different tables with the same criteria which is the lot number and the corresponding weight. In one table this lot number is specific to only one record whereas in the other...

I'm trying to have a text box that will automatically fill in the date whenever the form is filled out or when a record is brought into the form to be updated. How do I do this? When a record is brought into the field it will need to be able to change the date already in the field to today's...

Im trying to make a button that will take the record selected in a combo box and use that in a query as the criteria then run, and save that query then update it in the form then I would like to do some calculations based on the information sorted in the query. How do I go about doing this? Is...

Thanks it worked like a charm!

I am trying to get a form to open like the one in the Students Sample Database in the education folder under sample templates where it opens a form through an "open" feature on the datasheet. The way they have it here is based on the Autonumber ID but I want to get it to open based on a code...

I am trying to develop a way to print a label from data gathered through a query that will change/update each time the query criteria is changed. Any ideas?

Thanks All. I'll do some homework.

Spikepl, Can you expand on this: You can in the properties of the field in table design say Now(), so each new record is born with a time stamp. See how green I am? Thanks

I must be doing something wrong. I tried GotFocus() and didn't get the date cell to autopopulate either.

I'm not aware that the form has any restrictions. Lets see if this works: I stripped down the database to just a few tables most of the linked tables were removed. Don't know if that will cause issues. Thanks for helping.

Trevor, I's struggling. When the VBA screen opens there are several lines of text. I assume I insert the code between Private and End as shown. I changed YourDateFieldName to my field name of Date_Last_Modified. It looks like this: Private Sub Date_Last_Modified_AfterUpdate()...

Hi, New user here. When a new record in created via a form I need a field to auto enter the current Date/time.Can someone point me int he right direction?

Thanks for clarifying the operations of both Dropbox and Access. I found software called DATADIFF that appears to permit what I was trying to accomplish. Still working through it but so far so good. It compares 2 versions of the database, source and destination copies and partitions records...