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...

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

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 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:( :(

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...

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

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 = "'"...

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...

Can anybody tell me how to export a report as a text file with delimited. I am trying to use the "TransferText" but i doesn't ask me for a delimited. I can export it, but without the delimited. Please help

I have a report with some formulas, so I would like to convert this Report in a Table or Query. PLease Help!!!:(

I have a query that have three columns invoice number, tran number and amount. What I would like to do is to sum the invoice number if they are equal. example: new column Invoice #: 1345652 50.00 50.00 Invoice #...

Hi Folks!!! I need help. I would like to run a Macro that copy or delete all the odds rows. I have some information that needs to be moved. I would really appreciate your help...

I AM CREATING A SECURITY FOR MY DATABASE, BECAUSE IT IS LOCATED IN THE SHARED DRIVE. THE USERS CAN NOT DELETE TABLES OR ANY OTHER OBJECTS, BUT THEY CAN DELETE THE WHOLE DATABASE. HOW CAN I PREVENT THIS? ANY IDEA WOULD BE REALLY APPRECIATED!!! SECURITY FOR MY DATABASE

How Can I populate a parameter from a Form using a combo box. Thanks!

:( I have built a query to give an specific info, call it from a form, so if I mispell what I want then I get an empty report. I want to create a combo box from my form, that can run a report from my query. When I try to do it, appear the dialog box form my query. Can you please tell me how that...