Search results

Thank you for your help, your suggestion and links led me to learn that I could use a DMAX to get my EscalationFactor without a dlookup. Here is my field in the query: Val(DMax("[56ID]","[56ProdAddCost]","DatePPI <= #" & [ActualShipDate] & "#")) Sorry for the delay in responding! I'm not...

Thank you! I appreciate the links. I have never done a subquery or wrote in the SQL view. This is going to take me some time to comprehend what I need to do. Robecca

I am converting our invoicing out of Excel and into Access. I have 2 tables: 1. Shipping (table has the ship date in ActualShipDate) 2. PPIescalation (has an EscalationFactor that is used to compute the unit price; this EscalationFactor changes yearly on 6/5 and the table holds that date in...

Thank you Spikepl, I appreciate the link on "not in list" event. I will delve into it now.

@ spikepl - I have been trying to find documentation with no luck, when I try googling it doesn't bring up anything related to Access. @ Dave - it won't let me change the "limit in list" b/c it wants the primary key have a column width - which I have set to 0 since I don't want the primary key...

I have a combo box and a form on the List Items Edit Form property. When an item is entered that is not in the table, Access has a message box "The text you entered isn't an item in the list." I would like to bypass this message box from Access and just have my form listed in the List Items...

We are a small company and all employees have access to the server where the backend will reside. The owner is concerned with employees seeing areas of the database (salaries) that they do not have access to through their menus. Thank you CJ, that was very helpful! The links at the bottom...

I just designed my first multi-user database for our small company. The front end is all menu driven, however, I have a concern with the backend being on the company server where anyone can access it. Is there a way to protect it?

That does it perfectly. Thank you! I'll have to dive into the code to see how you got it to work. I really appreciate this!

Thank you for your time!

Since my data is all numbers from foreign fields due to being a join table to bring the item and bead parts together. I’ve substituted my numbers with the data. I realize that I can’t have repeating column headings with same, but that is part of my not knowing what to do … Thank you for...

I am designing a bead ornament database for my mom to track inventory of beads, inventory of finished ornaments and cost/pricing. I have a table that joins the Item and bead part with the quantity of each bead part needed, it has the following fields: ItemMatlID, ItemID, BeadPartID, Qty So I...

I rechecked my data for the week of 6/25 and there were no issues. I have the running sum control in the detail. I wanted to know by Bowler their composite average on any given week during our league. I never thought about the week footer, I will give it a try. It is fine

I have a report about bowlers & series. I am attempting to do a running sum on each bowler's series & games bowled each week, so I can get a new composite average each week. The data looks good until the 2nd to last row of data. The running sum on series & games bowled for every bowler is...

I guess I was having a rough day yesterday, I'd started out with an update query and next thing I know, my brain said I had to do an append query, which then led to a query to delete and obviously my issue with the autonumber when deleting/appending. Thanks Dave!

I have a table that was designed to store last season's bowling average for each bowler on each league they bowl. However, I now learned that one league does brackets (scratch & handicap) paid out after bowling that evening, but for the handicap bracket it has to use their average as of the...

Is it possible to create a query with a Sequential Number field? I have a table where I'd planned to have a primary key field to be an autonumber. However, now I need to delete all records from this table for the current year and then append records for the current year from a query to the...

Re: Navigation Form w/ Requery on Subform 2 - SOLVED In case someone else is looking ... this was solved with: [Forms]![NavigationForm]![NavigationSubForm].Form.[Subform].Requery The Subform is the "subform 2" name, the form I dropped on the navigation form is not mentioned. Robecca

I recently took an intermediate Access class and we were introduced to the Navigation form. I have a form [RecapSheet] that I put on a tab control [TabScoreEntry] in another form [ScoreEntry]. The tab control [TabScoreEntry] has a few tabs, one is Recaps which has an option group called...

Jiri, How do you make a pivot table editable? My brother wants a form that looks like the recap sheet I attached for entering game scores. Thanks! Robecca