Search results for query: *

I have 2 separate Excel 2007 worksheets that need imported into 1 table in Access 2007. Since I can only import 1 worksheet/import, how can I get the 2nd worksheet into the same table, matching up values from existing records? In other words, an append will not work. I need to match records...

I changed the SELECT statement on a combo box on my window, added a sort order by LastName and reversed the columns to be LastName, FirstName. Here's the problem. The combo box displays correctly in my mdb file. I send it to my client, they see it correctly in the mdb file as well...

I have an Access 2003 application that has a PRINT button. The clicked event code is: strReport = "Preview Timesheet" DoCmd.OpenReport strReport, acViewPreview DoCmd.PrintOut DoCmd.Close acReport, "Preview Timesheet", acSaveNo This works for me, but when my client...

I have a simple form with a sub-form. My form only allows additions. The sub-form displays the list of all previously added records. I have 2 buttons: "ADD TO PROJECT" and "CLOSE". There is only 1 field to enter the Project Name. My problem is stopping data from being entered without my...

In my database view, I am trying to attach a built-in Smart Tag. When I click on the ellipse button on the Smart Tag text box, the Smart Tag window pops up but there is only a Financial Symbol listed. I am finding nothing about the built-in tags in help except that they should already be...

I have a feeder query, then a pivot query that uses the feeder query, then a Pivot Report that uses the pivot query as its source. My problem is that when the report displays the data, some of the sums are null values. Therefore, I cannot get calculations done because of the nulls. I have...

I have a created a crosstab feeder query that joins my tables together, then created a cross table query that is used by a crosstab report. My problem is that my totals are incorrect and I cannot even figure out where the value being displayed is coming from. Please help! Feeder Query: SELECT...

I'm using db.execute to insert a record into a table. However, if there is a duplicate record, how do I check it? I have the dbFailOnError, but I don't know how to check it. Here's my code: Set db = CurrentDb strSQL = "Insert into [Time] (EmployeeID...

I am new to Access and am trying to understand the fundamentals of when to connect to a database. A lot of my confusion is because of my background in software development with much higher end languages. Here's my questions: 1. Since you create forms within an Access database, do you still...

I have a form that allows the user to enter information and click the ADD button. The ADD button adds the information to a specific table. I then requery a subform on the page to show the newly added record has been added to the list of previously added records. I need to be able to click...

I had the same problem referenced in thread701-953137. I added the Parameters code to my crosstab query SQL code. I still get the same JET error message but this time it says "The Microsoft Jet Database engine does not recognize " as a valid field name or expression. I cannot determine where...

Can someone please tell me why I get an error message on this query that JobType is not included in the first query? SELECT Department.DepartmentName, Employee.EmployeeNumber, Employee.LastName, Employee.FirstName, 'Regular' AS JobType, Sum(Time.Hours) AS SumOfHours FROM Department INNER JOIN...

I have a form and subform with my subform being a continuous form. It lists timesheet records in a Tabular format. I have a command button that has the following code to delete the record that has focus in the Tabular form: Private Sub BtnDelete_Click() With Me.TimesheetRecords...

I have a form and subform created. The form only allows the user to add a single time record to their timesheet at one time. After the ADD TO TIMESHEET button is clicked, the record is added to the subform (called TimesheetRecords) for the user to easily see what has been added. A Requery is...