Search results

Hopefully my title and question are using "null" correctly. I will also state that I did not develop this code on my own - I do not have the VBA knowledge to do that. I am following this guide from a guy named Martin Green. His tutorial is pretty amazing and I give all credit to him. I have a...

The Scenario: My database contains 6 tables; the one that needs updating is [tblProgramsGiven]. In this table is a memo field called [Notes] and in many records I put a note in about the lead person who gave the program. I decided to make a new table - [tblRangers] - that includes all the people...

After figuring it out, I believe the code was still pulling the user-entered value, or was somehow reverting the format to using the "/" character. I also followed my own inclinations - inspired by MarkK - to reorder my code: Private Sub btnExportPDF_Click() Dim StartDate As String...

I understand you're saying my code is no good, but beyond that.... :D I'm very new to writing code (and Access in general), and it's taken me quite a lot to get this far. I've only started learning VBA over the last few days because I realized Macros can't do all I want to do. Is my approach...

The user enters the dates in a textbox on "frmDatabaseReports" then clicks a button that opens the report. The textboxes are just named "StartDate" and "EndDate." On the report is a button that exports the report to PDF. I've changed it to keep the form open so it can pull these values, hence...

I have a form where the user enters a StartDate and EndDate to generate a report. If I want to export this report to a PDF, I would like the filename to include the StartDate and EndDate. I have the code below, which does not return any errors, but does not include the info in the file name...

Always learning! Good to know about the MkDir command. After mulling over this new information, and doing some more research, I decided to export the files to a folder on the user's desktop. For the way this database will be utilized (and restrictions on our network), this will work perfectly...

statement order = hierarchy At least the hierarchy the programmer creates. I guess I'm using it somewhat incorrectly just to make an analogy in my head. But let's not argue semantics :) Okay thanks I think I follow that. In reply to your end question: will this code only make the "Reports and...

After some searching I think I've got all the pieces to my necessary answer. But my limited knowledge of VBA makes it hard to put it all together. I have a button on a report, and on click it exports the query (which the report is based on) to an Excel file. However, I realized that if someone...

That's actually what I ended up doing :) I was in the process of testing a few ways to use this form as I typed the OP, and realized the text boxes were a no-go. Yesterday I had the difficulty of using cascading combo-boxes as part of the sub form, and not being able to store the data or...

Hey folks. Just posted an introduction thread in that forum if anyone is interested. I have a form/subform - frmCreditNewProgram and sfrmTeacherAttendance. These forms are built from a query that includes most of the fields from all of my tables. On the subform, users enter the name of schools...

Hello all. My name is Joe and I have been working with Access for the past couple of months; my goal is to build a database for my environmental education program. I have gotten a lot of assistance from the folks at "accessforums.net," but thought I would try a new forum for this question. No...