Search results

I am getting kind of lost. I try to run a function off of a button click. The code is Private Sub Command_Click() Run fuctionname() End Sub The code is ran, but then I get a msg box: Run-time error '2517': Microsoft Office Access can't find the procedure '.' What am I missing?

So I have a form, it has a few fields from a related table in it, related by the name. I click 'new' on the form, but when I click save Access complains about the related table does not have a matching record. How do I have it create a new record?

So I am exporting my data to PowerPoint. All is working well except I am stuck on probably a simple issue. :banghead: Dim pttestdue As String pttestdue = DLookup("persName", "Top 5 PT Status") Dim ptmonth As String ptmonth = Format(Date, "mmmm")...

Awesome, works like a charm.

DoCmd.OutputTo acOutputReport, "Breakdown Hourly", acFormatPDF, "Hourly Breakdown - " & Format(Now, "hh:mm") & ".pdf", True, "", acExportQualityPrint What is wrong with this code? Each time I push the button it shows the popup for microseconds, then does nothing. If I reduce it to...

ahhhh, the light bulb turned on. Thanks for the explanation. Off to see if I can implement it!

Okay, I think I asked that wrong. I have created a table with user id numbers in it. I want those people to have access to the form. Right now in the code if I replace the ######## with a user Id, that user id would have access to the form. How can I use that table of user ids, and give them...

So I am using the following code: Declare Function WNetGetUser Lib "mpr.dll" _ Alias "WNetGetUserA" (ByVal lpName As String, _ ByVal lpUserName As String, lpnLength As Long) As Long Const NoError = 0 'The Function call was successful Function GetUserName() As String Dim...

done and works wonderfully! Thanks!

Hello again, another question for you so I can inch closer to completing my project. I am creating a program to allows us to figure out where our personel are. I am using a continuous Form that shows the individuals name, phone numbers etc. and infront of that is a checkbox, and a combobox that...

Perfect! Amazing how I started with DCount, found info about Sum, and had to go back to DCount.

So I have created a continuous form, with a list of names, phone number, office location etc on it. In front of it I have a column where you can select members status, ie: leave, TDY, Not contacted. At the bottom I have a few calculations done using the code...

Okay, I solved the problem on my own. Thanks for looking.

any help on this? what am I missing? This is my code: Private Sub Command50_Click() DoCmd.OutputTo acOutputReport, "Page 1", "PDFFormat(*.pdf)", "1.pdf", False, "", , acExportQualityPrint DoCmd.OutputTo acOutputReport, "Page 2", "PDFFormat(*.pdf)", "Page 2.pdf", False, "", ...

I am using the code and took only the Merge part from it. Exported/Inported the database into mine and created a button that would create two pdfs, merge them and rename it. It works great if I first use the existing 'Form_HowToUse' to "Click here to Save this Report as a PDF document" , and...

Hello, I am creating a report with several subreports. I place the subreports in the page header for the report and the last one I work on grows to match the amount of records, and looks perfect. When I copy/paste that report (and switch to different data), that new subreport looks perfect, but...

So I am getting data from another database and i have the table linked. Created a query and will append it to my main table. When I append them I want to have them all added as students. The other table doesn't have a field called 'students'. Is there any way I can add that field to my main...

any help on this? Does the question make sense?

"NOt the same as your function, I hope? " You hoped wrong, the module and function had the same name :banghead: Thanks! This board has been great so far!

Oh my, each time I feel that I am getting a grasp of access, there is more to learn. I can delete a record from the query without a problem. I'm going to have to read that link and hopefully find the issue. This is for a database to keep instructors, new students and returning students...