Search results

This morning no one can access our database. An error comes up saying you do not have access to (then the path name) please check your administrator for appropriate permissions. What can be causing this? Please help - we can't get any work done....

How can I get a different main form to open depending on the user?? When a user at one of our offices open I need the first main form, when a user at a second main office opens I need a different form to open.

Before update on a subform, I want a custom dialog box to pop up saying "are you sure you want to save?" Right now the dialog box pops up after the data is already saved...Should this be in a different event.

My users find it hard to see the cursor in certain text boxes. Is there a pay to make the insertion larger or say a different color so that users can see witch text box the cursor is in?? My other question is...Is there a way within access on a termserver to automatically open up a database...

I have a validation rule on my subform that says If the number keyed in is greater than the number on the main form, an error message comes up. This has been working for a week now then all of a sudden it doesn't?? It will work if I key in the number 1 or if I key in greater than 9. Has...

Right now I have a messagebox popping up asking the user to verify their data before saving. The trouble is, the messagebox pops up right over their data. Can I have it pop up higher on my form??

Hi, I'm running Access 2000 on windows XP, the database is on our server that is using a package called citrix neighbourhood. I've been having tremendous trouble with my database. Sometimes I can't close out of a form, sometimes it won't let me open a query and today the program has just...

I have a form based on a table. There is a field that can repeat a number up to 6 times. Ex: Lot Number (Field Name) can be 4 in different records. I want the user to add a value in the form and all records where the lot number is 4 I want this value to update those fields as well..

Hi, in addition to the tab key, how can I let the user use the left and right arrow keys to advance to the next field on a form and where would I put the code??

I have a subform that checks a value in the main form. If the value is greater I get a messagebox box saying so - this works o.k. but now I want to setfocus back to this same text box and put the value back to zero before the user can change it or move on. Here is what I have but it just moves...

We have shifts that run from 6:00 one morning until 5:00 the next morning. I will need a report printed on demand where that user can enter the First Date and Last Date - this is no problem with a parameter but how do I only get the report to include the right start time and finish time?? The...

This may be pretty basic...I want some forms to open maximized in my database while others I want tp open to the size that I saved them. Right now, my main screen opens maximized but then the rest of them open maximized too. Is there a way to have each open to a different size??

Hi, sometimes a value will nedded to be divided into zero. When this happens, I need the answer to calculate to zero to be used in another calculation. Here is the code in the query that I am using to try to convert to 0 but it is not working...What have I done wrong?? LgQty...

I'm using Access 2000 on Windows XP. When I do a subtraction in a query such as 30,000-30,000 which should result to 0, I get the result 3.6379.......on and on. Does anyone have an idea what the problem could be???

I have a pretty complicated calculation in my query. Sometimes I get a value returned sometimes I get #Error. How can I get rid of this??

I am new to being a DBA. There are users keying into a database I created until 3 a.m. How I can review data that they have entered after I leave at 5 pm until 3 a.m. to pick up on possible errors? Or should I need to do this?

I hava form / subform combination that is opened from another form. The main form is opened with specific data that the user chooses and then they need to add the subform data. The people who will use the program probably have never even used a computer before. The problem is if they keep...

I have a form based on a query. Sometimes there may be no data in the query so the form opens up blank. How can I get a message box to come up saying "There is no data to update" instead of opening up a blank form and under what form event should I put this code??

Hi, I have a form subform combination. The main form opens up to a specific record but when I try to add to the subform I get the message "The linkMaster Fields property setting has produced this error: The object doesn't contain the Automation object (my table name from the main form). The...

Hi, I have a calculated value based on a subform and form displayed on my main form. When this value calculates to 0, I don't want this record to show. Only the records with a remaining inventory (that is a value greater than 0)should show. How can I only show the records on my form with a value...