Search results

hello friends, I need your help to spot an issue that I've tried to figure out for at least 2 hours. Im trying to export a query to a csv file based on a criteria. The code works fine until it reached the parameter to filter the query, see code below: Public Function...

Hello friends, I'm trying to come up with a simple solution to what I think it should be simple problem :unsure: :ROFLMAO:, but of course it cant be that simple... So I have an audit table with the usual fields: AuditID TimeStamp UserName FormName Action RecordID FieldName OldValue NewValue...

Hello forum friends, I hope everyone is doing fine. I'm trying to get pass over an error I'm encountering within my module. When function is called to record the entry in the tblAuditTrail, i get an error on ![FieldName] = ctl.ControlSource - Error 91 - Object Variable or With block...

Dear forum friends, I need your help with the following. I'm working in Offer report that prints on PDF, this works without a problem. The problem is that if the offer has 3 items in it, the offer prints with 3 pages (see attached). I have other reports in the program I'm building that print...

Hello there, I'm trying to print a report into a PDF file to later attached it to an email, but I continue getting the error : Runtime error 2501 on this line : DoCmd.OutputTo acOutputReport, PurchaseOrderReport, acFormatPDF, filepath I'm not sure what is causing this error as the...

Dear friends, I hope everyone is well. Thinking out loud here. I was wondering if its possible to execute a local command with VBA to query an external MySQL DB in the internet, for example: MySQL is hosting user names, and this command will go into the MySQL database and check if the user...

Hello there, I hope everyone is doing well. I've been trying to find a work around to add a record into a sub-form that is not by direct input into the sub-form, for example: I have the Main form that has the ID (autonumber), the sub-form is related via the MainID (ID_FK) and it has is own...

Hello friends, I need a hand with a DSUM calculation I'm trying to do, here is the test code: Me.qaTest.Value = Nz(DSum("[QtySold]", "tblSalesOrderHistory", "[SL_FK]=" & Form!SL.Value & " and [TransactionType]='Sale'" & " or [TransactionType]='Exchange'"), 0) I'm trying to add [QtySold] only...

Hello friends, Happy new year 2021! I hope this year is much better than last one, I don't think it will be really hard to make it better :LOL: Here is my finding while troubleshooting/testing. this is Inventory management DB - MS ACCESS 2016 I have tblSalesOder connected to...

Hello my friends, Here I am again asking for some support. I'm printing a label with the idea of using a barcode scanner, the source for the label is a Query. I'm using = "*" & [Field] & "*" in a unbound textbox, with the font Free 3 of 9 or also known as 39. When looking at the layout view...

Hello friends, I hope everyone is fine. I'm having a problem when printing a report after processing a receiving goods. The idea is to print two reports, one of them is a barcoded label(no problem), and the other is a report summary of the item received into inventory, this is the one printing...

Dear friends, I hope you are doing well. I've been running into a syntax issue when executing a update statement on VBA. The line in discussion: CurrentDb.Execute "UPDATE tblPurchaseOrderDetail SET lineStatus_FK = 2" & "WHERE [IncomingID]=" & IdLine & ";" lineStatus_FK is number (connected...

Hello all, I hope everyone is doing fine. I have an open question regarding orderTbl and OrderDetailsTbl. The tblOrder is pretty straight forward with the usual requirements, Supplier name, order date, etc. the table has an Autonumber as well. The OrderDetailsTbl table (connected with one to...

Hello all, i have a quick question, I'm playing with a database trying things and i came across something that i wasn't expecting, here is the issue: i noticed that ms access provides has an option to generate a custom autonumber, so i switched on (input custom sequence)to try the...

Hello All, I hope everyone is having a good night or good morning, depending on what part of the world you are :) I have the following problem that I've been trying to fix for at least a few hours. When I print a purchase order report from the PO form, the report shows everything but the...

Dear, I hope everyone is doing fine. I wanted to pick your knowledge regarding the Access web browser object that comes in Access 2016. I'm currently using it, and it works until I go into a more JavaScript intensive websites and thats when the problem begins. I start getting this famous...

Hello all, I hope everyone is doing well in these crazy times. I created a Input query to run based on a specific date. The input query retrieves the data from table X, the query works for any date except the current date(today), any ideas how to make it work for the current date? Side note...

Hello all, I'm reaching out to you all in the hopes someone can give me hand to figure out what's wrong with my code. Access Expertise: Bit more than beginner. Context: I'm putting together an inventory management program using MS Access, which includes: Purchase order Form, Receiving PO...

Hello all, Where do I start...Moved to the US when I was 17 years old, I graduated high school in Chile with a technical degree in programming. For different reasons I wasn't able to continue growing my programming career in the US. Fast forward 18 years, and now I find myself back where I left...