Search results

I have a form that contains several Radio Buttons. Each Radio Button will control the Printing of a Report. I would like to build a Case Statement that loops thru each Radio Button and for those that are selected print the corrosponding report.

I need to create an Inputbox using VBA Code and prompt the user for a value. Once the value is entered I want to be able to right an If statement that says If the value entered into the Input box is Y then perform this action....

Thank you very much.....

I have a Form with a Text Box and I would like to have the value of the text box be a field from a query. Basically when a Report name is selected in a Combo Box I would like for the report Description to show up in the Text Box....

Thanks a bunch!

I have two tables that I am pulling into a Union query. One of the tables has the invoice number saved as text and the it is saved as a number. I have tried converting the data type however Access says there isn't enough memory to make the change. Is there a way I can convert the data type upon...

Sorry attached is an example..

I have a table for which I would like to pull the last invoice for each invoice listed. I have tried to use the Max() and the Last() but because the Post Date can be the same it still pulls multiple. I am trying to get the last instance of each invoice. Below is a table that gives a visual of...

Thank you very much!!!

I would like to remove the last character from a string in a field using a query. For example in the raw data below I want to omitt the 'A' Raw Data: MLKMIW17508A LGMCM10007869705A FA08-4405A Results wanted: MLKMIW17508 LGMCM10007869705 FA08-4405

I am trying to transfer a Query (using a Spec and without headers) to a txt file using the transfertext method and I keep getting the error 'Run Time Error 3011' Microsoft Jet Database couldn't find the object 'EmDeonTest.txt' I am trying to simply export it to my desktop. If I could have it...

DKinley, that worked perfectly! Thank you so much for your help, I appreciate it.....

I have a form in access that I am trying to open if a username and password is valid. I keep getting Access can't find the Form error message. Below is the code I am using Private Sub Command5_Click() Dim Login As String Login = TxtLoginPassword If Login = "yalexander140843" Then...

The database opens it's just when a user clicks on a button that is attached to a macro to open a form the following message pops up:'A:\BAM\CustomerServiceTelephoneTracking.mdb' is not a valid path.

Rabbie, Where do I make this change?

Rabbie, I am fairly new at this what does it mean to use a UNC type name on the Back End Files?

I have a database that I split and placed on a shared network and when I copy and past the front end on other users computers when they try to open a form they get and error stating that database path isn't valid. Each person may have their network mapped with a different letter for example mine...

Thanks DK.. That worked perfectly....

I would like to hide a login form once the user inputs their ID and Passowrd and hits a button called login. I would like for the form to still stay loaded as I will be referencing text boxes on it from another form.

Paul, That worked, thank you for your help I appreciate it.