Search results for query: *

Looking for some help running queries based on a combo box. Have looked through the forums and couldn't find anything on running different queries based on values. I need to allow the user to switch back and forth between two different recipients of documents that are to be printed and...

I have an MS Access 2007 DB we are using to record and track user requests in (sales type stuff). We are also using this db separately as the source for a merge document which creates a document that is printed and sent back to the requestor. I have looked in this forum and others for a...

It has been a while since I did any serious work with queries and then of course my machine was upgraded to MS Access 2007 so there is probably some newer way to do what I need to accomplish. I have two tables, and need to use the value in Table A to return a value from table B to a query...

I have a table with approx 8000 records in it which contain names and addresses. Many of the names are repeated with different addresses. I am trying to break the table apart into two tables one for names and then a separate table with address records that relate back to the names. Each Name...

My users are asking for a button in an access form that will create a Windows folder (Directory) on a shared drive to store customer documents in. When we create the customer record in Access they want to have a button to create the folder using the CustomerID as the folder name. The...

I'm using the Export function in access to generate a semi-colon delimited file. My upload of this file failed for some formatting problem. when I got the diagnostic back, there were 3 characters on the front of the first row of my data that I didn't export and that I couldn't see in the txt...

I have a database to which I import names and other information about businesses and then export the data as delimited txt files. Users are very bad about putting restricted characters in the name field for businesses. One of the services that I export to is very fussy about only certain...

I have a form that has two text boxes for dates (these drive my report criteria). I need to be able to calculate a future date that is on a working day (M-F) off of the [EndingDate} text box. It would be even better if I could somehow weed out holidays, but I don't want to get greedy. Anyone...

I want to start by apologizing for posting this same info in the Access Forms forum......sorry all. I know there is a ton of info in this forum on sending attachments to email. In fact I have most of my email stuff being generated as SNP reports and attached because of you guys. I'm stuck...

I know there is a ton of info in this forum on sending attachments to email. In fact I have most of my email stuff being generated as SNP reports and attached because of you guys. I'm stuck though on sending the output of a query as an excel spreadsheet. I have a form that users pick a...

I have a data set of 2100 records (this time, the data sets are different each time). I need to check whether all 9 characters of a field are numerical. The data is stored in a text field. If there is one or more position that is not numerical, I need to produce a report with that field (I...

We have a multi user database ( I didn't design it only manage the users). 20 concurrent users doing data entry. Occaisionally we need to boot everyone off but some people don't exit properly and then we have to go PC to PC to find the one still connected. Is there a way to disconnect users...

Can anyone help with a couple of formatting questions: 1. I have a report that needs to take the appearance of a letter. How do I size the data fields on the report to shrink and grow horizontally to have proper appearance. I tried to concatonate within the query but if any of the values are...