Search results

haha, yes, sometimes we tend to over engineer the solutions :D:LOL: Rick

Hey there, Yes, in the US. Rick

Hello, I fixed the problem at the table level by formatting the default value like this: =FormatDateTime(Now(),2) // so every time there is a new entry in the table, the date gets added in this format: mm/dd/yyyy - Input queries are working perfect now. Thank you both! regards, Rick

Hello cheekybuddha, Thank you for your help as well. best regards, Rick

Hello Micron, Yes, that was the problem...Initially, I created the field without formatting it, so it created a mix long dates and short date entries after adjusting it. I think I know how to fix it now, thank you for your input. Regards, Rick

7/10/2020 I have other input queries that run from range, for example: Start date: 7/1/2020 - End date: 7/10/2020 - and it only shows data from 7/1/2020 to 7/9/2020 Thoughts? Rick

Here you go: SELECT NotesTable.CommentDate, NotesTable.PN_FK, NotesTable.Customer, NotesTable.PriceQuoted, NotesTable.Contact, NotesTable.Comments FROM NotesTable WHERE (((NotesTable.CommentDate)=[Enter a Date to display])) ORDER BY NotesTable.CommentDate; Thank you in advance. Rick

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 gasman, ive decided to move on and keep it simple for now. i did try the variable idea in one of my attempts to figure the issue out, but then the subreport (good receipts) of the parent report was not showing up. ill revisit at some other time. i listened to normalization videos today...

Hello Micron, I have been doing research here and there, I've come a long way :). nevertheless, of course there is still a lot to learn ahead. Ever since the last post I did here, I managed to have the form almost working. Regarding your comment about updating the database, I picked that...

Hello there, I checked on your recommendation and something strange is happening, even though I assigned the value of my Stockline to a variable... VBA after a few lines picks up the autonumber from the GoodReceiptstable ....what???:banghead::banghead: I tried assigning the value of the...

thank you for the insight! I will let you know if I can make it work. best regards, Rick

regarding your question *IF*, that's the reason I created this post. the good receipts report is suppose to print automatically every time you receive a line, along with a label for that item. I get to print the report every time, but every time I get the syntax error, so I presume that VBA does...

Stockline value is null depending on how you syntax the docmd.openreport. as I said earlier, I used different ways, and some of them work but other gave me the Null value you received. Let me know if I can provide you with further details. thank you so much for your help. Rick

Hello there, You are right. here is a description on how I usually start the process by going through the following steps: Click on : Search "FrmSearchPoReceive" Here is a list of open PO's 11 (Lines inside #2) 12 (Lines inside #1) 13 (Lines inside #3) 14 (Lines inside #1) 16 (Lines inside...

Hello, see attached, Let me know if it works. The form is FrmPoGoodReceipts Thanks in advance. Ricardo

Where do you upload when the DB is 15MB?

VBA is complaining for every case I tried. If the Purchase order has one line, it tells me syntax is wrong, I do the change and hit the play button, then it prints. I tried another purchase order with more lines, same syntax error, I changed it to how it was, it works and it prints....driving me...

here is the code for this action button: Private Sub ReceivePoLineBt_Click() msg = "Warning, Ready to receive Line?" Style = vbYesNo + vbCritical Title = "Confirm information!" response = MsgBox(msg, Style, Title) If response = vbYes Then 'Create variable to obtain number of open...

Sure. You need all the code for this form? do you need something from the report as well?