Search results

Pr2-eugin, Thank you for replying back. I’ve had lots of help from the various individuals mentioned from their replies and reading several posts, very thankful for that. I’m not 100% sure about DMax as I am still learning all of what Access offers, but I am comfortable with the current code...

Pr2-eugin, I am attaching my watered down version of the database so you can see what I see. The proposed solution of the code kinda works. It removes the extra [-] but now the value is ABC-14-500003 (one to many zeros). The second issue comes from the assigning the first Requisition Number...

This is a great alternative! The only issue I have with the coding is the format on how it is displayed based on the attached images. The format I am looking to achieve is ABC-12-60002 The current code produces ABC-12-60000-2 The dynamic part comes from other businesses using the database...

Thank you for the help. I know that line is wrong, but thats the general idea of where I want to go to make a form of LRS-13-60000, that adds +1 each time a new event occurs. My previous code did that, but had embedded values of LRS, 13, and 60000. I want to make those values dynamic so when...

Thank you for the response. I am attempting to concatenate strings together without any luck. I attached the error when running, basically comes from assigning a new requisition number. I cleaned up the first two parts that you suggested but I’m not sure how to “fix” the line...

I have specific numbers that are generated based on: [location],[year],[number] which is represented [LRS-13-60000]. Other locations may have [ABC-13-70000]. For each new purchase order, +1 is added to the number. Right now I am attempting to have my table [Codes] store the values of location...

I went ahead and started to change my coding for the RequisitionNumber. I am currently getting an error saying the value cannot be a zero-length string. I've attached my code, i'm sure it is in need of help! Option Compare Database Function NewRequisitionNumber() As String Dim db...

I have been holding off on doing this because of other projects inside the database but will work on this next week. I also need to figure out a way to separate the data further based on year. Our new business year starts October 1st. With the New Year come new Requisitions Numbers, new...

Made the changes, works like a charm! Thank you! We can't give thanks in the post anymore? What happened to the thumbs???

Private Sub Command60_Click() DoCmd.OpenReport “rpt_MultiSearch_PWO Report” , , , “PWO_Number = ‘” & Me.SearchResults & “’” End Sub

Thank you! I can only imagine the coding there, looks great and it looks like I will be busy!

=IIf(IsNumeric([Open]),"Open","") Uploaded a partical copy of what I have [sample1] with a few screen shots[sample2]. I went back to the original code in the DblClick: Private Sub RequisitionID_DblClick(Cancel As Integer) DoCmd.OpenForm "ReviewPurchaseOrder", , , "RequisitionID=" &...

I have read a lot about creating reports, and have successful built a few (as of now). I was wondering how everyone sets up the reports for the users to see. Do you create a form with a report link via command button? What if there is monthly, quarterly, or yearly criteria? Does anyone have any...

Bob, I haven't had any luck with the above code. I keep getting a run-time error '2447'. I am attaching a few screen shots: the error screen shot the #Name? on txtReqID when it is displayed in the datasheet of the split form (it doesn't display open) *i'm not 100% what you mean by binding it...

I am trying to change the current function to fit the needs of the years to come. I have table labeled [Codes] where the value of 'LRS' is stored. I'd like to have the option for other locations to use the database and assign their own unique ID [ABC] instead of the stored value below. Also I...

I updated the "Halloween" themed relationship lines! I know the OCC in both is "wrong" as far as typical relationships go. But I use the OCC on the requisition tbl to feed into another printable/editable custom form for the user based on the state forms we are required to use. I put this...

Attached is a snapshot of the relationships. The purchase order system is based on requisitions. A requisition can have many purchase orders, but any given purchase order can only have one requisition. This system tracks the purchases for the company by auto generating a specific PO number...

Boblarson's response is very detailed. That website outlines many important aspects such as what is the main thing you are looking to track. Think about what you want to track: Vendors, Customers, Purchase Orders, Purchase Order Details, Employees, Products, Etc. Research, brainstorm, write...

Hi All, I wanted to get some opinions if my query design is flawed or if I am going about this the right way. My numbers display correctly as of now, but I read a lot about running totals and using (DSum) which i'm not doing. I am building a purchase order system where I have a static...

Hello There!