Search results

Hi All, I need help. I have a table with heading that I want to see them in rows. For example: The way it is now: Group 3 Group 4 Group 5 10.00 5.00 3.00 20.00 15.00 6.00 The way I want to see it...

i have the following: Me.ActiveControl.Application.Visible = False but it is not working.

Can anybody tell me how to hide a subreport? I want to hide or unhide depending on what I am running. Please help. thanks

I have a database that creates emails from an spreadsheet, so populate the value in each email. but the only problem is that the loop not always work. When I click the button it just goes to the last department. See below my codes and let me know if anybody can help me. Dim Tbody As String Dim...

I have been using AutoExec macro to open my database automatically. But if you use the shift button, it doesn't work. How can I prevent others users to use the shift button to see the design of my database? thanks

I would insert a Right() formula in the Query. For instance, If you just want to see the last 9 digits(including space), I Would use it like this : Telephone : Right([field Name], 9)

Does anybody knows how I can have an access database in the internet? Please let me know.

I have a file in Excel and I need to export two sheets from excel to access for example sheet1 and sheet2. How can I do this using VBA? It's just importing the first sheet, I think I need to specify the sheet I want, but I don't know how to do it. thanks

I did that, but the color does not change. When I open my main form with the subform, the color is the same. I want to change the texbox(font) to Red.

I think this is simple, but I don't know. I have a database with a subform and I want to change the font color(ForeColor) to Red, but I can't. Please help:( :(

Now it works...thanks a lot SJ McAbney

Hi Guys, I am having problem with this programming, since my where condition is reading my parameters. My parameter strRPT and strDept are getting the assinged value, but my where condition is not reading them. Please help!!! Private Sub Command27_Click() Dim strRpt1 As String Dim strRpt2 As...

I know that I need to assign a specific value to a variable. My question is can assign is not null to a variable. I am passing the value to a SQL statement. I need help on this issue!!!!

I have a drop down in my form, so when I select All in my department Name, I want to assign is not null to a variable, because I have a SQL statement based on my variables, see below...Thanks in advance If Me.DeptName <> "All" Then strDept = "'" & Me.DeptName & "'" ElseIf Me.DeptName = "All"...

Anyone knows how to assign the a IS NOT NULL to a variable strDept = "'is not null'" ******** THIS DOESN'T WORK **********

I used the end if after the elseif code and it works... thanks a bunch!!!

I did not want to send the whole program, but all the end if statements are there. The combination of the first if and elseif statement is the problem.

Hi Guys, I am trying to do this small programming in VBA, but one of the below if statement is not working. The first If statement works, if I remove the second one and viceversa. If me.deptname is working. If Me.TypeOfReport <> "Both" Then strRPT = "'" & Me.TypeOfReport & "'" strRPT1 = "'"...

Hi Roger, This is fantastic!!! Thanks a million!!!

Can anyone help me to create an accumulative balance in a table if the invoice is the same. For example: Inv # Transaction Amount Balance 123456 10 10 123456 20 30 123456 15 45 321654 10...