Search results

I have a query that shows the open order quantity by month and a table that show projected ship pounds (based on production capacity). I also have a query that totals the amount of backlog pounds (previous month or earlier). I need to be able to add the backlog pounds to the current month...

Good morning all, I'll do my best to explain the issue... We have manufacturing machine that exports a lot of data about how long it takes to complete each "pass" and the speed of the machine at any given interval when running coils of material. If I limit the time increment to only minutes and...

Good evening, I have 3 tables of monthly usage data that is updated daily using "rolling 12 month" criteria. I'd like a summary form that shows MTD, as well as the previous 11 months usage for each of the 3 categories (tables). Since the month names will change every month (rolling 12), I...

Good afternoon! I have a field in a linked table that contains several alpha-codes for machine processes (this table is downloaded from our company system, not a table that I created or can modify). Each of these alpha-codes has a corresponding number of days for processing. I've used a...

Good morning all, I've spent two days scouring the web for a solution to what should be a simple problem. I've got a summary form that displays various metrics for the month's shipments. The form has controls that reference several queries based on one table. I have Dsums and Dcounts that...

Good morning all, I'm going to try and explain my issue as precisely and concisely as possible... I have an imported table field that is a series of alpha-codes, concatenated with ",". Each code identifies a process step and corresponds with a certain number of days left in the entire process...

Good afternoon all! The following code works exactly as I need it to - by double clicking a master form, I can open and populate fields on a child form. The problem is that the code is telling the form to open in a new window, and I'd like to just open in the subform window (I don't want to see...

Good morning! Super novice question, I think. How can i add another value to this code: Private Sub TagNumber_DblClick(Cancel As Integer) DoCmd.OpenForm "frm_IPOAllocationWorksheet", acNormal DoCmd.GoToRecord , , acNewRec Forms!frm_IPOAllocationWorksheet.TagNumber.Value = Me.TagNumber End...

I use DLookUP all the time - that's why it's particularly frustrating that I can't get this one to work. It appears as a control in a Textbox on my form "DailyReviewForm". I want the textbox to be populated with the data from the field "MFGPart" which appears in the table...

Good afternoon/evening! I have formatted form based on a query, that allows users to double-click some of the form headers, and access the Quick Filter menus, tailoring (and sorting) the form for their specific needs. I also have a report based on this form - same information in a...

Hi! I have a form that's been working just fine for months - until today. There are a total of 1015 records. I can see all of these records until I switch to Design View to make a change (formatting, etc) then when I change the view back to Form, the navigation counter still says 1015 but I...

Hi all! I'm trying to convert a well-used (and well-loved) Excel spreadsheet to a better-suited Access form and so far, so good. There is one feature from Excel, however, that I can't seem to duplicate in Access, and it's an important feature for my co-worker. He's become very dependent upon...

Hi! I have a form that has approximately 100 controls but I only need 10 tab stops. Is there anyway to set the tab stop setting to "no" in the property sheet, en masse, and then add it back in to the 10 controls? Thank you!

Good morning, I have a form that uses conditional formatting to color code an [OpenOrder] date field. There are currently 5 different conditions that result in four different colors for the field. The intended users of the form are not super familiar with Access so I'd like to create a button...

Good morning all, I'm not new to Access but I've been on Access hiatus for several years and I'm realizing that building databases isn't exactly like riding a bike; I've forgotten a few of the basics. I know this request is super elementary but I can't figure it out: I have a query...