Search results

I'm creating a simple form in WORD using the forms toolbar. I've inserted several text form fields, formated the background and created a protected template as explained in the online help. The form looks great until I go to use it. When I begin entering the text in the fields, my "protected"...

I'd like to format a report that shows my production totals in a calendar style format with the seven days of the week across the top and the production totals for each day of the month displayed like a calendar. Sometimes there is no production on Saturday and usually no production on Sunday...

I have a screen showing several report icons. It would be nice if many of these reports were filtered by month and year to limit the size of the reports to data of interest. What I'd like to do is have the user select the report icon, bring up a small form so he can choose the month and year...

I have created five simple access databases that are used by 25 people on 15 PC's. Any one of the 25 people can use any of the PC's to log in and run any one of the five applications. I've been using the Tools-Options menu to disable the Windows in Taskbar setting so that the taskbar is not...

Sub Report Headings not on Report I have a report with three subreports within. The subreport headings are not showing up on the report but the details of the subreports are being reported. Is there a propery setting I'm missing ?

I'm using a combo box from a table for a pick list to fill a field in another table. The text comes up and I can select my choice and this all looks good but the text isn't being stored in the field, the key number is being stored. Why is this happening ?

I have a Table that will record chemical (antibody) use in fields as follows: Antibody_Name Lot_Number Order_Date Received_Date Open_Date Exhaust_Date There are several chemicals, each from a specific manufacturer. So I have another Table as follows: Antibody_Name Manufacturer I want a form...

I have a report based on a query. The query sorts records by year and month, both in decending order so that the most recent records appear first. When I run the query - it works great. When I run the report, the data is not in this order. The correct query is shown in the report properties...

I have a form with a combo box that I'm using to limit data shown on another form that's data source is a select query. Once I've selected the filter criteria on the 1st form, how do I get the query to run so that the results are displayed on the 2nd form? This seems like Access 101 to me...

I'd like to use a macro to import a text file that has the date as an integral part of the name such as WL-Jul13.txt or WL-Jul14.txt Each day, I want the user to start Access, have the user select the file to be imported (usually the for current date - but not always) and then Access will...

I recently implemented barcode scanning to AVOID data entry errors and wouldn't you know it, a new error has arisen. Users are scanning patient case numbers from the patient paperwork to print labels for slides. Here's the problem - when the cursor is positioned in the case number field...

I am unable to open two databases that have been in use for several months. When I double click the shortcuts Microsoft Access opens with an error stating that it cannot file the file, check to make sure the path and filename are correct. The path and filename are fine - I see the files in the...

I've searched the forum and this must be so easy that no one has ever had to ask .... I'm importing a text file as part of a macro and want to delete the first two rows (records) in the new table. The first row contains text and the second row is all blank. My "cleanup" query has no problem...

I'm using a query to set-up the format for my report. My table has 5 fields: [Case] [Patient] [Specimen] [Block] [BlockNum] A patient may have more than one specimen, which in turn may have more than one block. The blocks are identified as A, B, C etc. The BlockNum's are 1, 2, 3 ... n...

I have a text format operation that works fine on my home PC but not on the PC at the install site. I thought maybe it was a library issue but all the functions are in the library. I changed the following which works: SHORTPAT: UCase(Left([PATIENT],10)) to SHORTPAT...

I'm having a problem using a barcode font.... I've downloaded the IDAutomation code 39 font that has been recommended elsewhere in this forum and I'm having trouble getting letters to format properly. Numbers work fine. I've converted all my letters (last names) to uppercase since I'm just...

I set up a query used to create a report. In order to display the data in a desirable format, I've defined a new field in the query and perform some simple functions. When I go to run the query, I receive a message relating to the new field "Enter Parameter Value" where its allowing me to...

I was told by our IT people that multi-user Access implementations are not allowed on our network because they require too much "bandwidth". What is bandwidth as it applies to network applications and is it common for Access to be excluded due to this ? Thanks for your input.

I have a form with combo boxes used to select items for my master table. The first combo box has a list of facilities, say A, B, and C. The second combo box has a list of departments at each facility for example Facility A has D1, D2, and D4, Facility B has D1 and D3, and Facility C has just...

I have a combo box used to enter field problems and is later used to classify data for graphing. The problem is that when the users select the type of problem from the list, they then add notes to the text forming a new unique field problem which results in a new classification. For example...