Search results

Just a guess, but try holding down Shift as you open the database.

Is there a way to run the SQL statement to only insert records where the category and subcategory equal "Opening" and "Side Door"? For example, if my record was: (111, GA, Trailer1, Opening, Side Door, Red Door, $400) I would want to insert (112, GA, Trailer1, Opening, Side Door, Safety Door...

I am trying to Insert/Append the table.

I'm looking to insert some data into my table called tblModelStandards. tblModelStandards has the fields ModelStandardsID, PlantCode, Category, SubCategory, Description, Cost. I'm trying to insert "Door Safety Chain" and "$3.00" into Description and Cost where Category is "Opening" and...

Well I figured it out. I don't know why this worked but it did. My combobox was based on a query called qryDealers. In the query I only had one field, DealerName. I added another field to the query so I could filter some of the dealers out. Once I added a second field I could change the...

I have a form that has things like the date, a dealer name, the quote number, make, model, and cost for a quote that my salesmen create. There is a button on this form called Change Dealer that allows the salesmen to change the name of a dealer. Change Dealer button will open another form with...

Awesome! Would you like to be my new hero? This worked perfectly. In case anyone else ever needs this, I went with option #2 and used the code you supplied. I did change the line of code to: strCell = "Q" & intStart because "Q" was were my Boolean field was. Thank you!

Hi. I am trying to export two queries from Access 2007 into Excel. I would like the queries to be on separate sheets within the workbook. I have this working the way I would like. In both queries I have a Boolean field. If the Boolean is Yes than I would like to highlight the Excel row red...

Good point. I changed it to Decimal (18,2). It now stores my decimal if the Quantity field. That solved it. Thank you!

Total Cost is stored. It has a data type of Currency. Cost is currency as well.

I feel like this a dumb question, but how do I show a decimal in a text box? Here is what I have. I have a SQL back-end and Access front-end. The user selects an item out of a combo box and then text boxes for Unit of Measure, Cost, and Description are populated. The user then has to enter...

You could try this: Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) ' Prevents use of the Close button If CloseMode = vbFormControlMenu Then MsgBox "Clicking the Close button does not work." & vbCrLf & vbCrLf & _ "Please Exit by...

Maybe with a recordset? Loop through the recordset a look for a match. If is not in the list set focus to the other combobox and after the user selects from the second combobox add the record to the recordset.

I had the same question. This looks exactly like what I need. Thanks!

When I use ADO for the DealerEmail table I get a run-time error saying: Invalid object name 'DealerEmails'. I assume this is because of the code on another form where I load the connection: Option Compare Database Option Explicit 'ADODB connection to tblBrand Public adoDealerBrands As New...

I am using Access 2007 on my front-end and SQL Server 2014 on the back-end. I have a table of Car Dealers and a table of contacts at the dealerships. These tables are SQL tables. The user can select a dealer and then see everyone that works at that dealership. When they look at this there is...

Thanks. That did the trick. Of course I've developed a new problem. I only ever see record 1 in my Contacts table. I must have a problem with a join somewhere. Thanks again!

Hi. I am trying to use a combo box to refresh a subform. I am working with Access 2007 as my front end and SQL 2014 on the back end. On my main form called frmDealers I have an unbound combobox where the user selects a dealer and then text boxes are populated with address and phone...

I don't know if this is the problem, it could be my computer, but it looks like to me your second If statement as a space in RecordsetClone between the O & N: If Me!subNewPartF.Form!subNewMetalF.Form.RecordsetClo ne.RecordCount > 0 Then Same thing with the third IF: If...

You are correct. Changing Column Count changes how many columns I'm seeing in my combo box. So with that said is there a way to have Column Count = 1 and have it unbound and still populate the text boxes?