Search results

I have a button that opens a script file which maps network printers to the computer. Everything works fine except when clicking the button Access open the script file twice. Any idea why that is and what to do to make it only open once? Thanks

I'm using the docmd.sendobject to send a report as a pdf file in an email, but I would like to be able to send a couple other reports in the same email. Is that possible?

I have a combo box that displays 2 columns when clicked. First Column contains a number and the second is a description. I want to be able to select the appropiate item and then show both values in the box and also store both into the table. How do I concatenate or get them together to...

How can i compare a string to check and see if it has an asterick in it? I know an asterick is a wildcard character for any number of characters, but I want to check and see if my string has one at the beginning of it then bold that particular string. The closest I got was bolding all my...

Is there a way to export a report to word in a format other then RTF? I have a lot of stuff on this report and the RTF doesnt keep the boxes that I have in the report and they help break up the sections of the report. Thanks,

Is their a way to use special characters like "&" in a label on a form?

Another dept at work wanted me to look at a problem they are having in there database. I've fixed a couple of the problems but now I'm down to this problem regarding a SQl string, and recordset and could use some help if you can. I'm getting the error "Run-Time error 3464, Data type mismatch...

I'm trying to pass 2 variables to a function so I dont have the some code repeated a bunch of times just for different variables. But when I finish the call statement I get a "compile error: = expected". If I take the second argument out of the call the error goes away, but it wont work without...

I'm trying to lock a text box after 55 characters have been entered but for some reason it doesnt lock and lets me keep typing in the box. Below is the code I have for the box. Any ideas what I'm doing wrong? I've stepped through it step by step and the len(txtDescription) will = 55 but it...

This probably isnt so much an Access problem but I really didnt know where to begin to find an answer to this so I thought I would start here since you all are very hepful. I made a script file that will put a shortcut to a databse I made on peoples desktop. It has worked for everyone but...

I made a database that opens to a main menu form adn for some reason when I click one of the buttons there it does nothing. But when I click it a second time it does what it should. It doesnt matter which button I click when I first open it either. Any ideas what might be causing this? It...

I made a button open an excel file, but my problem is when it opens the excel program it opens maximized but the spreadsheet file opens as a smaller window in excel. Is there a way I can tell it to open to the max size? When the file gets open by double clicking it it opens maximized like I...

I'm trying to load the current user into a combo box when a form loads up. I have a query that uses a function (which pulls the logged in username from the computer) and matches the username to the actual name of the person which works fine. But I also want the cboName on my form to use a...

I have a form that people often forget to select their name and area before submitting. So I'm trying to add code to just pop up a window saying you forgot to enter your info and exit the sub before submitting. But for some reason the code in my if statement is NOT running. I ran the break...

I'm having problems getting my switchboard button to run a function I created. I'm guessing its something in the way my code is written, the name or something I'm leaving out, but I'm not seeing it. If you have any idea please help me. I went through the switchboard manager and set the...

I apologize if this has been asked before, I tried searching the forum but didnt see this particular issue. I have a number of combo boxes on a form and have set the tab indexes to tap through them in the order I want, but when I try to hit the down arrow to select a value in the list it moves...

I have 2 tables, one that stores contestant numbers (tblContestants, and Contestant Number is the PK) and one for an event the contestants participate in and get judged (tblCooling). tblCooling gets the contestant #'s from tblContestants but through a lookup combo box which I have to manually...

I'm making a database for a judging event and I've made a form that pulls all the contestants #'s from the table then has a bunch of combo boxes for each element of the event for the scoring. My problem is when I change the combo box for one element it changes it for all the contestants. How...

I have this reminder form so when I run it it tells me who hasnt done thier monthly assessment then I click a button to send an reminder by email. But it does everyone seperately and I'd rather just send one email. Is there an easy way to put multiple recipients in a email created by Access...

I have some code setup to send an email to people as a reminder to do do their monthly assessment, and in it I list the location of the database but I would like to make it a hyperlink instead. Below is an example of what I have, any easy ways to change it to a hyperlink? link =...