Search results for query: *

Hello, I have searched the forums and can't find an answer. I get a runtime error '3134' with the following insert statement: Private Sub cmdSaveQ_Click() DoCmd.RunSQL " insert into tblquotes" & _ "(tickname, tickprice, wfsize, bordername, borderht, borderprice, qdate, style...

When I enter a photo into a form (using Access 2000) by right clicking on the photo object>insert object, I get a thumbnail photo that contains the photo's name. Why doesn't it take up the whole photo object? And why is the photo's name there too? I tried this on the Northwind Database and...

I feel very uncomfortable w/Access 2007. I have Office 2007 installed, but want to use Access 2000. Can I have Access 2000 run on the same computer that has Office 2007 running? Must I remove Access 2007 first? I appreciate any help. Steve

I have a DB with 3 tables: Fantasy Teams Players Transactions This database will keep track of which fantasy team drafted which (real football) players. The Transactions table has a lookup field that displays all the players. I want the players to be eliminated from the lookup once they are...

I have a worksheet w/many prices on it. We are having a price increase of 12.5% accross the board. How do I update all the cells w/numbers in them? I prefer not to use code. Thanks, Steve

I have a list in excel with customer name, address, city state, zip. I want to sort the list alphabetically and by zip. Alphabetically works fine, but sorting by zip doesn't. Basically it's sorting my one list as two sorts in one list, as if half the list is sorted, then it sorts the other...

I created a database for a user. He has added many records. He requested some new forms and reports, which I created on my copy at home. How do we keep all the new records he entered and import them into the new database structure?

I have a report that uses 2 user entered dates to display the sales in the time period between the two dates. I also am calculating the year to date sales in the same report using dsum and abs functions. I want the year to date sales to use the year entered by the user in the start date field...

I often work w/data on an excel spreadsheet and compare that info to a report in access. Is there some utility or program I can use to split my single monitor into 2 screens so I can work w/both apps at the same time? It would be great if this utility could divide my screen vertically and have...

I have made a form w/a text box for Store Name and a second one for date. When I press the command button it runs a select query and opens a report based on my input. When I substitue the text box for Store Name w/a combo box (and use the builder to add the combo box into the query) the query...

I have a one table database from which I made a data access page. I uploaded it and my database onto my internet provider home web page so I can view and use it at work. However, when I click on the link all I get is the title of the data access page, but no form elements such as the text...

I have a loans database where customers make monthly payments. I want to enter the payment (I know how to calculate what is interest and principal) then add the principal paid and interest paid as a new record to my transactions table. Must I use code? And if so, how do I do it? Thanks, ElSteveO