Search results for query: *

Hi, I'm putting together a "credit card manager program" with MS SQL Server 2005 Express and Visual Basic Express. If I'm filling out the curent Credit Card payment on a VB form, and I want to see the previous payment listed in a text box on this form, I'm stuck. I'm OK with the front ends but...

Hi, I'm putting together a "credit card manager program" with MS SQL Server 2005 Express and Visual Basic Express. If I'm filling out the curent Credit Card payment on a VB form, and I want to see the previous payment listed in a text box on this form, I'm stuck. I'm OK with the front ends but...

I just work in the office, It's up to the IT department to perform updates and install drivers. Even though it's got them stumped, they would not apppreciate my unsolicited advice. Are all IT departments like that? At least I got it to where it works. Thanks everyone.

Our IT department has not solved the problem yet. I can work around it by switching over to the "MS Office Document Image Writer" and it works. But if I want to use the default printer that is on the network, it hangs up. Has anyone found the fix so I can use the network printer as the default...

In both cases of converting it and not converting it, it does not print when the network printer is set to the default printer. And I can't even open a report in design view. I told the IT department about it and now I get to see what they figure out. I will post the solution if they find one. Don

Page setup is set to Default Printer. I need to ask IT if they installed any printer drivers. It's starting to look like it's driver related. Thanks All Don

Hi All, The company I work for has been using windows 2000 with Access 2000. My office manager just got a new computer with windows XP and Access 2003. When the default printer is set to the network printer, reports will not work. I can't even preview a report or open reports in design view. But...

I added the references from the 2000 machine. But that did not fix it. I did find out some interesting information though. The aplications work fine if the default printer is the (Microsoft Office Document Image Writer)that comes with Access 2003, But if I make the network printer the default...

I'm not at work right now so can't give you the exact error. But, the application runs about 4 reports and none of the preview report command buttons do anything. And the print report command buttons generate query error messages that I can't quote right now. The computer that was upgraded is my...

Well, it's not a mde file. The I.T. guy at work thanks that the code is different for 2003 but after checking Tek-Tips, I don't see that mentioned at all. It's starting to look like a bad install? Thanks everyone for your help. Don

Hi All, The company I work for is upgrading from Access 2000 to Access 2003. They are using Windows 2000. Now Access 2000 applications are not working on Access 2003. The forms command buttons that use to run reports are getting error messages about the queries that the reports run off of, and I...

Private Sub Command9_Click() I swear this site is great! This is the one that works for me. It's those parentheses that I couldn't figure out. Thanks every one. Expecially PH. Don ***************************************** Dim x As Variant Dim var_1 As Variant Dim var_2 As Variant Dim var_3...

Duh, The else statment gives me the reverse. If x Like var_1 Or x Like var_2 Or x Like var_3 Then MsgBox " x is equal to one of the values in the list" Else MsgBox "x is not equal to any of the values in the list " End If Thanks for helping me I really do appreciate you all. Don

Thank you all, If I use "AND" then all 3 variables have to match x. I'm trying to have the msgbox pop up when none of the individual variables match x. I got it to work with: If x Like var_1 Or x Like var_2 Or x Like var_3 Then MsgBox " x is equal to one of the variables in the list" End If...

OK I'm not a profesional programer but I do like making Access aplications with VBA. I'm stuck on a simple argument: If not variable_1, variable_2 or variable_3 then msgbox Any clues as to the syntax for doing this in VBA??? I could maybe figure out a funcky way of doing it but it wouldn't...

Thanks all, Dcount worked perfit: Dim IntCountRec As Integer IntCountRec = DCount("[FieldName]", "tblName") If IntCountRec < 1 Then Exit Sub Else Run procedure End If You don't know how much this site has lifted me up. Thank you all!!!!!!

Hi All, What is a good way to check a table to see if it's empty, then return a value that I can use to exit a procedure? Any help would help me keep my job, and impress the powers that be, or not. Don

Thank you all, The link that TheAceMan1 sent works perfect. This is the best darn web site in the world. Thank you Don

The label Wizard alows me to print one particular address label at a time. How can you print a full page of a particular label? Thanks in advance Don

Using the Label Wizard, alows me to print one label for a particular address. How could I print a complete sheet of labels for a particular address? I got stuck on this one. Thanks in advance Don