Search results

I never had this problem before with the db or the network printers. All users can print with no problem. I changed the default printers on the users to a local printer and told them to select the printer if they need to print. They print items right now that are not from the db. I have another...

OK, split the database and put the be on the shared drive and put a copy of the fe on each machine. I see the purpose behind this method. But, I still have the problem. I could fix it on a temporary basis by changing the default printer, why I don't know but it works after one failure. I have to...

David, the desktops have Norton and the laptops have Trend data. Rabbie, I sorry but I am not familiar with FE/BE. What exactly do these terms mean and how do I use them. If it is the better way to work then I will put it in place. Can you provide a link to documentation on how to set up this...

Yes, There is one mdb file on a shared drive on one computer. The other users map to that drive and then open the db from there. It works from my laptop and another laptop and the desktop that the database is stored. Two other desktops and one other laptop have the problem. The laptops all have...

Thanks, I will give it a shot.

I am having a problem that I have never encountered before and thought I start here. Using Access 2003 I have a database that resides on a main computer and my users connect via the network to this database. On my forms I have command buttons that run simple macros to copy and paste data from...

I created an Option Grp. Two buttons one YES(True) and one NO(False) and false being my default What I want to happen is this, when yes is selected update the Priority field to HIGH. If NO is selected, in case the user marked it critical by mistake, to change the value of priority back to...

I have a form called fhd2_Help_Desk. I want to put a check box on it that when checked it will update another field and if unchecked to update that field with a different value. I added a check box called Critical and the control source is a field called critical. It is a yes/no field and the...

The form control for the STNO field. The STNO field on my form belongs to the HelpDesk table. This is where I record the issue being taken. The problem is when a stno number is not in my Keysheet table. I think I need to put some kind of code in the before update or lost focus of the STNO field...

First I like to say this forum has always been helpful with my db issues. So thanks to all the experts. This is a problem that I have been avoiding for a few years and need to get it corrected. My database is a Help Desk program used for post cut support of large PBX systems. I have two main...

That was/is my plan but haven't had the time to create a form with the tight cut schedule we are on. I need this as a reminder only since I forget this step sometimes. This database is a tool I use and no one else. I would really like to learn VBA since it seems that it is the better way to go...

What I like to know is how to get a dialog box at the start of a macro to remind me to set a primary key on a table before the rest of the macro continues. The macro that I run is made up of many other macro's but if I forget to set the primary key on my main table (as I did yesterday) I then...

Thanks for that last bit of info. Sorry I didn't check back earlier but have been really busy at work and haven't had a chance. I will try your last suggestion with a backup copy of my db. I need to have the FAC field as text because I could and do have values that start with 0. But if there is...

Got it, it works now. Thanks!! What happened was when I created the field FacID in my table I made a typo and named it FaxID. I didn't notice this until I added the control to my form. I went back to my table and corrected the field, I checked my query that is the control for the form and it was...

Thanks again, almost there. I entered the code word for word except for names. My table is named: tbl_Fac_Codes, My PK is named: FacID, and my data field is named: FAC. Private Sub Fac_BeforeUpdate(Cancel As Integer) Dim varData As Variant varData =...

My volume is up and sound is working on my laptop. Only Access won't beep. I created a test macro to bring up a msgbox with beep. When I run it, there is no beep from access.

So it is best that I create a new field lets say called Index and make this my primary key and set it for auto number. Remove Fac as primary key. I can then set the Fac field as No Duplictes then I would be able to do what I want to do easier than if were the primary key. Am correct in saying...

The Fac field is my primary key and is set for No Duplicates. If you enter a code that is already in the table the message that appears is not clear to the users. "The changes you entered were not saved because they would create duplicate values in the primary key field ... I want a simple...

Thanks that worked! This is the code I used for leaving the Fac field blank. Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.FAC) Then MsgBox "You must enter a Fac code" Cancel = True End If End Sub Just 2 more questions Can I make the box...

I would like to know how to display a msg box for missing or duplicate information when entering data into a form. My database keeps track of call accounting codes and the code is the primary key index field. I use macro's for all of my automated tasks such as finding codes, filtering for...