Search results

Here's a simple little function that demonstrates converting a date into it's weekday name. Hope this helps! ----------------- Function WeekdayFromDate() varDate = InputBox("Enter a date:") varWeekdayNum = DatePart("w", varDate) varWeekdayName = WeekdayName(varWeekdayNum) MsgBox (varDate...

The additional fields could make a difference. Also, Access doesn't like something about the Excel data (e.g. text trying to go into a numeric field, duplicate values in a primary key field, etc.) Try importing your Excel spreadsheet into a new table and then see if you can figure out what...

From the code associated with your first command button, display the browse dialog box and store the full pathname of the selected file in a variable. Next, create a second command button to do your Excel spreadsheet import. Below is a sample of the VBA command: DoCmd.TransferSpreadsheet...

Paul, THANKS so much for your help! Your first query gave me the two dates I needed. (I never would have thought to add the same table twice ... Give yourself a gold star for the day.) For the second query I was able to simplify things a bit by using a totals query. I joined the Customer...

Hi all … I’m working on a customer billing system and this one has me stumped. I need to figure out the average amount of each customer’s last two bills. On the surface, this seemed like an easy query; but I’ve run into problems because not all customers have charges each month. The table...

An import specification is used to define the layout and structure of the file you’ll be importing. (e.g. field name, data type, size, etc.) To create an import specification, act as if you were going to import your file manually. From the File menu, choose Get External Data, then choose...

Ben, You can create a function to delete your real table and then copy your backup table to the real table again. DoCmd.DeleteObject acTable, "real table name" DoCmd.CopyObject , "real table name", acTable, "backup table name"

Create a totals query and use it as the record source for your report. In the query, you should group by the Broker first, then group by the Check Number and finally Sum the Amount.

Assuming you have a table that contains the users name you can use a form with a combobox to let the user select his/her name. In the row source for your combobox, use a select statement like the following. select distinct [name] from [table_name] order by [name] Then in your query, use...

First, go to the following web site, copy the vba code, and paste it into a module in your database: http://www.mvps.org/access/api/api0001.htm Next, create and save an import specification for the file you want to import. Last of all, create a command button that calls the open dialog box...

One option would be to create a query that selects only the equipment records that you what in your report. Then, use the query as the record source for your report.

It is tricky; but even with different headers/footers you can still put everything in the page header/page footer of your main report. Here's the basic concept of how this works. PageHeader text1 text2 text3 text4 text5 text6 For subreport#1 you only want to print...

You can get around the subreport header/footer problem by putting all of necessary headers/footers fields in your MAIN report. This does gets a bit tricky though. For each of your subreports, you'll have to turn on the visible property for the fields you want printed and turn off the visible...

I don't know if this will work in your case, but have you considered creating a report that contains each of your 8 reports as sub-reports?

Your union query fields should take on the same data format as the fields in your first table. One suggestion would be to reverse the order in which you select fields from your two tables; but, that won't solve the PK problem. Another approach would be to use append queries. Create a table...

Jennifer, To expand on Pat's idea ... after counting the number of records, if the count is greater than 0, display a message box with Yes No buttons. In the message text, tell the user that there are child records and ask if he/she wants to delete them now. If the user answers "yes"...

In your query, go into SQL View and type in your select statements The first select statement establish the name and order of fields within your query. Example: SELECT LastName, FirstName, SSN FROM Table1 UNION SELECT lname, fname, SS_Num FROM table2 In your query results set, the fields...

I can't comment on why your code doesn't work; but here's a suggestion that might help you out. Create a saved query that calculates the average values you want in your list box. Next, use a simple SQL statement (in the row source in your list box) to select the average field from your...

One point that needs to be clarified -- When you refer to “Datasheet View” do you really mean, “when you open the TABLE”? Forms can also be used to display data in “Datasheet View” and using a form gives you a lot more flexibility to include event code. To do what you want, create a form with...

Pat Thanks for your help! You were right about my table not having a PK. It has an identity field that was originally defined as the PK. Recently, our DBA upgraded our SQL Server from version 7 to 2000. Somehow during the upgraed all of my database's PK's and indexes disappeared. After...