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...

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...

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...

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?

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?

I need to be able to syncronize databases from multiple field deployed laptops. I was hoping to do this via Dropbox but have run into conflicted copy issues. Does anyone have suggestions on an appropriate way to syncronize data across multiple laptops that are not hard wired to a server or the...

Hi, I'm a relatively new ACCESS user. Swithed our database to Access this last year to gain added functionality over a simple databse we were using previously. We are using ACCESS to house botanically related scientific work in the western US. I need to be able to syncronize databases from...