Recent content by Rustaferd

Paul, Thanks for the explanation. The more I work through these problems...the more I am understanding how the software works and with your kind and generous help I have gained a lot! I did create a new macro and put only that code which is what I need and pointed to the new test macro and...

This is interesting. Is it possible to do the same thing, but instead of a command button, could this date stamp be done by selecting from a combobox? If in the combobox I had the option of Closed, Opened, ReOpened, whichever is selected, a date stamp would be entered into that field? I can...

I have a database with a form called Main. In the Main form there is a status field (combobox). In the status field are 3 selections - Open, Closed, ReOpened. Also in the Main form there are 3 text fields: Opened, Closed, ReOpened What I would like to do is select Open or Closed or ReOpened...

This sounds like a great idea! If anyone figures this out, I'd like to know the answer as well. Russ

I checked and couldn't find this in the status properties. It may be an issue with the macro, but not sure. SetCallDateOpened IsNull([CallDateOpened]) SetValue ... Requery ... SetValue SetCallDateClosedReopened ([CallStatusID]=2)...

Paul, Just so I understand, when you say go to the Form module, are you talking about selecting the Form Object where all the forms reside? If so, are you suggesting I open each form and look for fields that may have EditCaller_Click? I don't suppose Access has any type of search tool? I...

When I enter a new record, the Opened Date is populated with the current date. But if I select Closed from the Status list I get this message: Ambiguous name detected: EditCaller_Click There is no EditCaller_Click that I can find. In the Status properties I have a link pointing to the macro...

Paul, Thanks for your response. I will see if I can put together some screen grabs and post it up on my website. A picture speaks more... I'll let you know when this is ready. Thanks,

I have made some progress with my HelpDesk database. However, I have noticed when testing the Open, Closed, ReOpen Dates do not work when I select the Status. In my Main Form I have a Status field with Open, Closed, ReOpen - when I make a selection the date fields should change, but they do...

Here is my attempt at the code I am trying to achieve: SELECT [valPerson].[PersonName] AS Name,[valPerson].[PersonID] AS ID, [valCompany].[CompanyName], [valPerson].[PersonPhoneNumber], [valPerson].[PersonPhoneExt], [valPerson].[PersonTypeDescription], [valPerson].[PersonIntlPhoneNumber]...

Zemp, Thanks so much for helping me understand a little better about sql. I know very little but am trying to learn,thus the reason for pulling some code and disecting it. The one thing I forgot to mention was there there is also no company type. So would the above sql statement be written...

I am working on a database issue and need to resolve this piece of code. Can you or anyone else understand what is happening here? I need to take out certian parts, but if I do, I get syntax errors. How can I remove anything to do with Facility, or department? I don't need these,but the code...

Visual Basic for Application Microsoft Access 9.0 Object Library Microsoft ActiveX Data Objects 2.1 Library That is all, Talk again on Monday. Thanks, Russ

Okay - I am still working on this Help Desk Access database. The problem I am running into is when I am creating a command button. This button when selected is suppose to open the person form so that I can add a new caller. Name - Command247 Caption - A Status Bar Text - Add a Company...

I am continuing to work on this Access Database and have found a road block with the Visual Basic Modules I want to create. I know nothing about Visual Basic with Access. When I select New (to create a new module), I can enter my text for the code I want to create, but when I select save it...