Search results for query: *

I can create queries without a problem, and they work fine. However, I can't save them. Everytime I try, I get an error message: "The changes you requested to the table were not successful because they would create values in the index, primary key or relationship. Change the data in the field...

Hopefully this is an easy question! I have changed a couple of things in my BE table. However, the FE is not recognising the changes. How do I relink the data (if that's the right term)? FURTHER DETAILS I have a combo-box field that shows list values (Monday-Friday). I have updated the list to...

Hi all, This is a follow on from thread181-843073. I have been reading up on splitting a DB into FE/BE set-up, but I have a few queries, as I am not totally sure I know what I'm doing.... (I have numbered the steps/queries to make it easy for wonderful people to help me!) (1) To practically...

Hi, We have several access databases that are used in our office. Most people are running Access 97, while a few are running Access 2000. The databases are secured, and everytime the Access 2000 users try and open a database they get an error message telling them they don't have the necessary...

Hi, I have created several databases for the office in which I work. However, not knowing what I was doing, I secured each them using a different Workgroup Information File. Since then, I have been informed that I can use one WIF for all the different databases, all I have to do is set the...

We have multiple databases in our office that were created in Access 97. There are various databases that do various things, and different users need different permissions for each database. What I have done so far is create a different .mdw for each database, but I'm not sure that this is the...

Nobody seems to have replied to thread702-810987, so I thought i'd ask the question in a more simplified way. I have a form called frmOrder based on table tblOrder. In tblOrder there is a memo field called GoodsComments. In frmOrder, instead of placing GoodsComments directly on this form, I...

1. I have a table called tblOrder that stores data on orders placed. It has various links to other tables, such as tblSupplier, tblProject, tblStaffMember. (There are actually two relationships to tblStaffMember, as there are two fields in tblOrder called OrderedBy and AuthorisedBy) I have a...

This is probably a really dumb question, but.... If i define a variable and then assign a value to it, e.g. Dim ThisDay As Integer ThisDay = DatePart("d", Now))) Is the value assigned to ThisDay saved when the DB is closed, or is it lost?

I have a textbox (txtJobStartDate). In order to calculate the amount of time the employee has been employed, i have another text box (txtYearsWorked) with the following control source: =(DateDiff("d",[txtJobStartDate],[Date]()))/365 This gives me the amount of time worked as a...

I have a textbox (txtJobStartDate). In order to calculate the amount of time the employee has been employed, i have another text box (txtYearsWorked) with the following control source: =(DateDiff("y",[txtJobStartDate],[Date]()))/365 This gives me the amount of time worked as a...

I know this is a REALLY easy one, but I can't seem to find the answer! How do you sort the records shown on a form, by alphabetical order using VB Code? For example, I have an form that shows all client information, but it is currently showing them by ClientID order (Autonumber). How do I...

I have a DB where, upon loading or changing of Form1, an expression is evaluated. If this expression is proved true, then a message form (Form2) is opened. Form2 is Modal, and the user can only continue by pressing the OK button (which closes Form2). Unfortunately, whenever Form2 is opened, it...