Search results

Can I have a database load a form with command buttons that opens another database that will open the databse within the currect session of access. What I have is terminal services setup and accessing a server using remote desktop. I have access execute upon login which will open a database. I...

Have a link to a database (.mdb) file hanging off of the internet on a site. When I click the link to open the database, it give me an access error that says it is outside of the local intranet or not a trusted site. I hvae attached a screen shot.

Could someone lok at this database and see why only one query is not updating its table. The qry in question is qry_Sweep Account When frm_Sweep Account is filled out and the email button is clicked, it updates tbl_Sweep Account with the info and should update tbl_ID10 with an Auto Number to...

Ok, I will try to explain what I need to do. I need to have a record with a unique number (account number). This account nuumber can have as many people attached to it as need be (lets say 4). But, I want to be able to charge an amount ($) to each person within the account and keep their...

Have a form with to text box feilds, option1 and option2. When values are manually entered into them, want it to add then together and place to total amount into a total field the is part of table1. How do I do that?

Have currency coming over from a link table. Appending it to a table, running a query to select certain records off of the table. Have a report that makes it look pretty that is ran from the query. I need to be able to take the number (say $553.54) and have it round down to the nearest five...

What is the code to start a form maximized?

Running a query that is asking to inout a vaule ( [Enter O-OPen or C-Closed] ) When That question appears, how can I have it default a vaule in there but also give the option to change it? Thanks.

Getting this error while running an append query. Will get it one time and not the next. Why would this be doing this, there are not any feilds that are to small to handle any numeric data. AS a matter of fact, there is only one feild that has a numeric value and it is only 12 digits in size...

Importing data, need to force a decimal point to the left of the right 2 numbers. Should this be done on the link table or in the query? Thanks.

Running an append query, appending to table, get notification that it cant append all records. That is OK, I dont want it to tell me that. Can I turn it off? Thanks.

Is there a way to update several reports at once. What I have is 12 seperate reports, SL1, SL2, SL3, etc..., the detail in all of them are the same with different report footers. It is setup this way because they are used at different times for different reasons. I would like to be able to...

I want to, when a report is closed, to have a macro start. How and where would I do this? Thanks.

I am importing some data (ex., 00012 and 00001) with a link table. Then I am using an append query to dump the info into a table. How can I make the leading zero's disapper and appear as 12 and 1. I thought about setting up the format to exclude the leading zeros, but where there could be 3...

Can you add a page break in the report writer? Thanks.

WHen creating an update query, there has to be a value in the Update To field. How do I get that to prompt me for a value. I have tried the standard [Enter Date], that does not prompt me for a value. Thanks.

Need to update several humdred records at once, would like to have an easy way of doing that witha select all check box or something like that. Look at the attachmentto see wha I have.

Have a query based on database that has check boxes and a date field. I would like to be a ble to check all at once, a select all button if you will. I would also like to fill in the date field the same way. Any suggestions? Thanks.

Have a query from 2 linked tables that have a relationship. I am pulling some records based on some criteria. It returns what I want, but sometimes the same person could have several records, I am getting all of their records. I need to exclude anyone that has a matching address. Does it...

How do I have a report select record from a query based on a range? I have a query that has a date field, I want to select records based on that date field from a date to a date (8/20/2003 to 8/25/2003). Thanks.