Search results

I've been struggling with this for awhile now. I've been trying to research a solution but I'm not even sure what to search for. I have the following table structure: tblContacts Contact_ID (PK) First_Name Last_Name tblBidPack Bid_Pack_ID (PK) Bid_Pack_Description tblDistributionList...

I've thought I had a decent understanding of database normalization but I've come across a fairly simple problem that I'm having difficulty resolving. I have a database which I use to track submittals from companies. Originally it was set up as follows: tblCompany Company_ID (PK) Company...

I'm trying to create a report that will look like the attached spreadsheet (it was the easiest way I could come up with to explain what I need). The report is grouped. The biggest problem I'm having is trying to draw a line after the last record in each group. At this point I've only drawn...

I have the following code in the on_load of all of my forms to disable all menus: Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i The problem is that when I open a report in preview mode I cannot close, print, etc. Two questions: 1. Is the above approach...

I want to disable the button "cmdNew" unless certain criteria are met. Here is the code that runs in Form_Current : Private Sub Form_Current() Me.cmdNext.Enabled = (Me.RecordsetClone.RecordCount > Me.CurrentRecord) Me.cmdPrevious.Enabled = Me.CurrentRecord > 1 Me.cmdLast.Enabled =...

I have a main form with an unbound combo box. I also have a subform showing records in datasheet view. on the after_update event of the combobox I want to filter the subform. Here is my code (note frmqrysubmittals is the subform and the recordsource for the subform is initially the RS1...

I'm having difficulty designing the structure of a datebase that will track product submittals. My submittal table has the following fields: tblSubmittals: Submittal_ID (Autonumber) (Primary) Type Contractor Description Status Revision# Comments Here's my dilemma. If the submittal is...

I have a main form with 2 subforms. Subform 1 shows the results of query 1, subform 2 shows the results of query 2. Query 2 uses query 1 as a starting point. Query 1 is updated with an option group on the main form. In other words, when I select an option on the main form, qdef for query 1...

I am using transferspreadsheet to output a query to an excel spreadsheet. I then want that spreadsheet to open automatically. If I code the filename in the call shell command it works fine, as in: Call Shell("C:\Program Files\Microsoft Office\OFFICE11\excel.exe ""C:\Documents and...

I have a tblWorkoutLog which contains workout data (body focus, excercise, date, etc.). I have a listbox (populated from a table) which allows a user to select a/several body focus (arms, legs, etc.). Once the selections are made, a query is created with the IN command to filter based on the...

I have a database that I use to track my workouts. I am very new to Access and am just starting to learn some simple VBA code. I have the following tables: tblBodyFocus Body Type tblExcercises Excercise_ID Excercise Body Type (Foreign) tblWorkoutLog Log_ID Excercise_ID (Foreign) Date...