Search results

after much frustration, I figured it out. The SELECT coding has to be in a precise order. The above code was telling access that the Agreement_Num had the tbl_RETAINER_GRANT_FUNDING ID instead of the tbl_GRANT ID. So I just switched the order to: "SELECT tbl_GRANT.Grant_ID...

After a lot of searching around I figured out how to make it work: Private Sub Retainer_ID_ON_UPDATE Dim strSql As String strSql = "SELECT tbl_RETAINER_GRANT_FUNDING.[ID], tbl_GRANT.[Agreement_Num], tbl_GRANT.Grant_ID " & _ "FROM tbl_GRANT INNER JOIN...

so I put that line in my code and it shows the Code that you referenced above, not sure how that helps my though. It's showing the correct Retainer_ID number, but when I apply it in my form, instead of out putting the Agreement_Num it outputs the Retianer_ID.

I have a field that shows dates as quarters. Right now it is just a date/time field, but that posses a problem, as the user can enter any date possible. I want the dates to be limited to March, June, September and December, and any year they choose. Can someone please help me with this. I tried...

Hey All, So I have a bit of a problem. I have two tables, tbl_Retainer tbl_Retainer_Grant_Funding tbl_Retainer has the field, Retainer_ID and tbl_Retainer_Grant_Funding has the fields, Retainer_ID (a lookup field from tbl_Retainer) Agreement_Num (a lookup field from...

I have a field that shows dates as quarters. Right now it is just a date/time field, but that posses a problem, as the user can enter any date possible. I want the dates to be limited to March, June, September and December, and any year they choose. Can someone please help me with this. I tried...

Thanks for the reply. I searched the IsLoaded and came up with code that worked; Private Sub Report_Close() If CurrentProject.AllForms("frm_Main_Reports").IsLoaded Then Forms!frm_Main_Specific_Reports_Project.Visible = True End If End Sub Private Sub Report_Open(Cancel As Integer) If...

I have a dilemma and I can't figure out the best way to go about this. I have a few reports that I open using different criteria, therefore producing a number of different reports. I have a popup form that displays all of these reports. As it is common knowledge, a report opens behind popup...

Thanks for the help. I Googled what you suggested and found my answer. Below is the full working code: Private Sub cmdOpenReport_Click() On Error GoTo Err_cmdOpenReport_Click Dim LReport As String Dim LCriteria As String Dim LFilter As String LReport =...

Sorry for not being clear, let me try again. Before I implemented the drop down box to open all reports I had separate buttons for every report. Some report buttons use the same report, with different where clauses. For every report that opens, I have different titles that become visible to...

Gotcha. So I changed the line where I had LFilter by itself and made it Reports!LReport!LFilter In my VBA I had Reports!MyReportName!Title.Visible=True So LReport will display the report I am on and LFilter will show, Title.Visible=True. But I am still getting a syntax error...

Got it. But now I have a somewhat relevant question, hoping you can answer it. So I used the code below, Private Sub cmdOpenReport_Click() On Error GoTo Err_cmdOpenReport_Click Dim LReport As String Dim LCriteria As String Dim LFilter As String LReport =...

ok, so maybe I don't have it. I know you don't have a copy infront of you but can you look at what I have and tell me if I am close. Private Sub cmdOpenReport_Click() On Error GoTo Err_cmdOpenReport_Click Dim LReport As String LReport = DLookup("Report_ID", "tbl_Sys_Reports"...

This is really great info. Can you show my some of your VBA though, so I can have a starting point. I am not that great creating VBA but when I have an example I know how to customize it for my own database.

I have a question. I have a lot of reports I have created. A lot of them are the same report but with different criteria. Right now I just have a report form, which displays all of the reports with buttons and the user chooses the desired report, clicks, and bam. In an attempt to make this look...

AHHH, I got it. Thanks so much guys. I figured out how to add it to the query and it worked perfectly! Awesome.

I have been on the simplest thing for so long and I am going crazy! I have a text box in a report that was calculated, =IIf([RemainingGrantFunds]<([Grant_Amount]*0.2),"1","0") So, if certain criteria are met, either a 1 or a 0 will be shown. Then in my OpenReport VBA I have...

I figured it out: Put the following code after your OpenReport line in your code; Reports!ReportName!ControlName.Visible = False

the 'project number' is in the header of my report, excluding the details of the report. when the report is filtered to a particular project, that project number will show on the cover page. but when it is not filtered, and displays all of the projects, the cover page will only show the project...

Not sure if this can be done, but giving it a shot. I'll start from the beginning and work through it. I have a form that has a drop down box with all of my project numbers in it. when I choose a project number, I can then choose from several report buttons on that same page that opens a...