Search results

If this is a catalogue, why would you send it out in crappy Excel format. Why not just place your reports from Access on the ftp. You have a number of options for output format including .pdf if you have that ability.

I used to work in LA (Lower Alabama, of course) and we had a number of coon a$$es that were related to Boudreaux. Some were cousins and others were nieces and nephews and they also talked about how people would disappear when he came around. As a matter of fact, I think that the reason we...

Do you want to encode the entire .mdb or just the data. If it is the data then I would assume that you find a Windows UTF-8 font, although Access help says that Arial Unicode meets Unicode 2.1, and install it on your computer. It should then be available in Access.

Is this voice recognition software? If it is, Microsoft recommends a high quality mike for it. Even if it isn't, the quality of the mike may be the problem.

As far as GUI, you can make it that by using icons for your buttons e.g. a trash can for delete. However, to me that is not a "no brainer." A no brainer would have complete descriptions written on the button. I developed a db for the DoD and had to write senetences on my buttons so the...

Calculating is the least of your worries right now. As Colin says, you need to set up your table as he describes. Once you do that, then ask the calculation question.

Of all the dbs I produced for my company, NO USER ever screwed with a table structure or a query design! You asked how to keep users from messing with them. Do you really mean people. Users usually have a vested interest in the db working properly and won't screw with it. Now, I have had...

Try CutePDF at http://www.cutepdf.com/

No need for two queries. Put similar code in the other field that you want to search. The *'s will take care of you not entering anything in one or the other search field.

Conceptually, create a query that will return the record that you are viewing on your form and then output a report with that query as the recordsource to rtf. Place this code in the On Click event of a button on the form: Private Sub button_Click() DoCmd.OutputTo acReport, "nameofreport"...

You would be better off to have just one table with an additional field of OwnerCompany. You could use the company names from this table to fill in that new field in a form combobox.

What is a "sub-record kinda thing"? Do you mean that you have duplicate data in the two tables or unique data in each. Either way, you are finding out the difficulties in doing whichever it is. How much are the details "pretty much the same? Tell us the fields in each table and maybe we can help.

Actually, you shouldn't place the combobox in the table. Do as noelgarry says and use the combobx wizard on the form. It will step you through the process.

I built a meeting room scheduler that would draw the time blocks that a room was scheduled. It would fill in the purpose and the scheduler in the block from info in a table. There is a way in VBA to do this but I can't remember the exact coding. I left the db at work and stupidly, it wasn't...

I would put DoctorID and PatientID in the tblCompaint and ComplaintID in the tblFollowup. Logic: When you get a complaint you will want to know who the patient is that is complaining and against what doc. Later, when a followup occurs you will want to ID which complaint is being followed up...

You could use a continuous form that has check boxes with each record you wish to select. When you selecte a button to move to wherever you are going after the selection(s) create a string of all the IDs, comma separated, and use it in a Filter that says ID in (string).

You say you have ftp, why not distribute via that? I know it isn't a CD but when you run out of room.. you run out of room. You could set up a back end front end scenario where everything except the table of data you are sending is in the frontend and your changed data is in the back end. When...

Create a batch file that checks for the existence of the file prior to starting Powerpoint. You can use If exist to do this and then start Powerpoint and add the ppt that you want it to open. Sorry I can't help you with exact code but this may be a start. Use Windows Help and type in Batch.

A little off topic but you can have people send or post you a zip file with another extension like._ip. When you get it change the extension back to .zip and away you go.

If someone wants menus like the Switchboard, I will use a regular form that will close when another form is opened and then will reopen when the other form is closed. Do this through control buttons. I, however, prefer toolbar menus. They are out of the way of the forms and always visible...