Search results

Hey, I created an application in Access 97 but French language and when I tried to convert it to Acces 2002, I got a few error messages, the errors are all about formulaires which means forms in english, therefore I went back to my acc97 db and I modified all the formulaires to forms...That...

Hey, I created an application in Access 97 but French language and when I tried to convert it to Acces 2002, I got a few error messages, the errors are all about formulaires which means forms in english, therefore I went back to my acc97 db and I modified all the formulaires to forms...That...

Hello, I have the following code in my form, but I need the code to loop when the user, doesn't have access to the PC...Right know what happens is that when the user doesn't have access I get the message "YOU DON'T HAVE ACCESS FROM THIS PC" and it still logs him in. I want it to EXIT and not...

Thank You so much, That worked..... Thank you again

Yes it is, ComputerName

Hello, I entered Me![ComputerName].Column(2) in the recordsource, but when I run it it doesn't work.....It doesn't put the info in the textbox......I get error with the name... #Name?

Hello I have a form and I also created a ComboBox named "ComputerName" and a textbox named " CompCycle" These fields are both independent, I also create a functionthat when the formis opened I can see the computer Name of the PC. What I would like to do is that I would like to link both...

I have a hyperlink on a form. When the user clicks on the hyperlink a second dbs opens. The problem is that every time a hyperlink is clicked and the db is opened it adds an entry in the Internet Explorer drop down address list. Why does it do this and how can I get it to quit doing it? I do...

I have multiple forms in my program, but 2 of them have to always remain open, therefore I entered a timer event at 15000. But what happens is that everytime a form refresh because of the timer I set, then no matter which form I am on, the form that just refresh pop up in the front off all the...

Hey Jeff, I replaced everything with ************* Private Sub Form_Timer() Dim dbs As Database Dim rst As Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("qryDispatchAll") If rst.RecordCount >= 1 Then DoCmd.RunCommand acCmdRefresh Else...

Hello, I have a db that is for a multi user environment. But I noticed that if 2 users have it open at the same time, and the I click on a button to terminated a call, well the other user is still able to see that call. I have a timer set to 20 000, but the only way that the call disappear...

I tried to ad this in my criteria of the query but I keep on getting eroror that I forgot a comma, or the operator is not valid...etc..... Tried both

hello I have a query that has a field named BeginDate. I need to add 3 years to this date...HOw do I do this is a query.. I think it's something like this...but I am not too sure dateadd("y",+3, date()) Can anyone help me...

Hello, This might be a really easy question, but I just can't see where the property is.. I have a few textbox and I aligned then to the left, but I am trying to aligh only the text in the textbox to the bottom.... Example _______ hello _______ I would like to do _______ hello _______ I...

It's because I have a few forms that call the reports and some of them I want to be able t print in Portrait and some inLandscape...I also have to make sure that if I am using it from another PC it stillworks fine.......

Hello , I have a db that has a form and when I choose the View or Print Option and then I click on the PrintButton. It will print out my report, but I want this report to Print or be viewd in Landscape..... This is the code I have in my form to print the report...

Ok thanks I will try this after lunchand willlet you know..... Thanks

I already tried that and still didn't work......

Hello, I have a Form named "Ecran_PCP_form" and I have a combobox that is independent but the source is SELECT DISTINCTROW tblUsers.User, tblUsers.Password FROM tblUsers; Then I have a list box that the source is SELECT tblUsers.User FROM tblUsers WHERE...

Hey Pat, Ok I linked the 2 tables, but I am not to sure how to do the APPEND query, can you please help.....