Search results

At work, I have a MS Access database I "inherited" managing and updating from someone who only used macros (database built in 2014). We have several users all with their own FE applications. All applications & Excel programs have trusted locations set and macro settings are enabled. We all...

Our BE database is password encrypted and only I can get in it for maintenance. This morning between 7:15 & 7:20 a record entered 3/9 was just "gone", basically as if it never existed. I don't think we would have ever noticed this if it happened in April to the same record, but we're working...

Our summer bowling leagues does brackets. We’ve been determining the bowler order for the bracket “manually” by drawing a random playing card. I would like to have Access assign the order randomly instead. A bracket has 8 bowlers. We have 10 brackets a night. I’m very new to coding VBA but...

I have just started getting this error as of 2/6/17 our database has been functioning since 1/26/15. I am now running MS Office v2016 after upgrading July 28, 2015. Microsoft VB Run-time error '-2147023170 (800706be)': Automoation Error The remote procedure call failed. Here is my code...

A customer is requesting a .txt file from us to import into their new system. Here is their requested format: H Unique 20161107 20161107 I 5500000021 110 4100000031 DBW1 20161107 2430848 LB 8010004405 SC 110 4100000062 LPT1...

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...

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...

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?

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 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...

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...

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...

I am building a bowling database and I had a tabbed form for entering games, however, my brother would rather have a form that looks like a recap. I don’t know how to get a form to look like this when it takes 4 records per bowler. My Scores table has these fields: ScoreID (PK) CheckInID (FK...

I had all my tables built and I started desiging my queries for my forms. I did not have any problems with my tables until now, when I started to bring build the queries/forms for team points. My database is for our summer bowling league. We have teams of 3, each week we draw for team...

I am designing a bowling database for our summer league (my brother's brainstorm). I have a table Score that has the following fields: ScoreID (AutoNumber) ChkInID (FK - Number) GameID (FK - Number) LaneID (FK - Text) Score (Number) So, for each bowler and game, there will be 1 entry into...

I hope I explain this well. I am designing a database for a summer bowling league. This league's teams change weekly based on a blind draw. So I check in each bowler each week. I have a table Score to capture the games bowled. This table has a Primary Key ScoreID (auto numbered) and it has a...

Hello I’m working on a bowling database … I built a form (BowlerCheckIn) that has 3 tabs – “Check In”, “Assign Teams”, “High Pots” “Assign Teams” tab has a multiple items form “AssigningTeam” on it and this form is based on the query “AssignTeam”. After checking in the bowlers on the “Check...

Hi, my name is Robecca and I am new to forums. I'm in the west coast of the USA. I have been using Access since 1994 but have never gotten into complex forms or VBA until now. Looking forward to learning a lot.