Search results

Hello all - It's been a while. I need to update my database, and now I'm rusty since it's been over a year. I need to alter my query for "todays tickets" . When a user submits a ticket, I have a field "Ticket Date" that now also includes the time. So it's a date time field. My query no...

Hi everyone! It's been a while. I've successfully dodged any additional programming for a few months, although now I have a simple, or so it seems, problem. How in the heck do you combine tables? I have an excel file that I tried to import into my Access 2k db to an existing table and got...

I've searched the forums and have found info on disabling the shift key in Access 97 but how do you do it in Access 2K? Of course I would also like a way for me to be able to bypass whatever security I set up. Anyone know? I'm not a great progammer so I'm hoping the solution isn't too...

Seems easy enough but! I have a form that displays all open tickets in tabular format. I have used the wizard to create a command button to refresh the form's data. Trouble is it only refreshes the tickets currently shown. So if a new ticket comes in, that ticket will not be included when the...

After being agravated at the way the command buttons looked (that dull gray), I changed them to labels. Now I would like the mouse pointer to do something when it is over the label. Either change to a pointer and then maybe an hour glass after it's clicked or change the color on the label when...

Suppose I got a little bored and decided to put an image of an American flag on my form. While trying to find an image I found some nice flag wallpaper. Is there a way to set that as your background for your form? I think it would look nicer (perhaps). Is this something that would be...

I have the below code on the double-click event. It works sometimes. The times it doesn't is when the ProblemDescription field (which is being used to match the record) has a quote in it. As an example, the problem description might read: I can't logon to the LAN. The ' in can't causes a...

You know how when you go into an application, sometimes you get an informative message with the option to choose to never show that message again? How do you do that in Access 2K? I would like an informative message to pop up when a form opens, basically explaining a few tips on the forms...

Because it seems so easy/obvious, and I have an idea how to fix it, it's implementing the fix. But here I go anyway. I have a print button created by a wizard on my form (form is based off a query). When I press the print button, the current record being displayed (along with the theme)...

I'm running office 2000 with A2K I have a button on my form that when pressed takes some info from the form and places it in the body of an email. Everything works fine if the user does what they are supposed to...but we all know we can't count on that. When outlook opens and the user decides...

I have 4 navigation buttons (first, last, next and previous). I used the wizards to create them. Here's the code for the next button: Private Sub cmdNext_Click() On Error GoTo Err_cmdNext_Click DoCmd.GoToRecord , , acNext Exit_cmdNext_Click: Exit Sub Err_cmdNext_Click: MsgBox...

Rather than a problem that needs to be solved....which we all post so often, I just wanted to say Thank You. This forum is a lifesaver and it's almost like having an Access expert at the next desk. (In my case it's better b/c my expert is a real SOB) Thank you all, I can be reasonably confident...

I have a trouble ticket form where the user inputs the problem description. That is the only field they can alter. Here's what I'd like to do. When the user goes to *add* to a ticket that they had previously submitted, I would like the date it was added to be inserted before their comment. I...

Hi Remember my question a week or so ago...I have a form with every field locked and disabled except one. When the user enters the form all the text from that one field is highlighted...thereby if a user hits any key all the text is gone. I have found a way to have the cursor go to the...

Hi Remember my question a week or so ago...I have a form with every field locked and disabled except one. When the user enters the form all the text from that one field is highlighted...thereby if a user hits any key all the text is gone. I have found a way to have the cursor go to the...

I have a form based off a query. There is only one field where a user can enter data. When the form is opened to the first record the text in that field is automatically highlighted so if a user accidentally hits a key, it wipes out the data. I've looked all through the properties and can't...

I'm using Access 2000. Is there a way to have a button on a form that when clicked will open up Outlook (Outlook 2000) and insert a copy of the Access form in the body of the email? Thanks for any help on this. Amy

I would like to have a user click a button on the main form that will bring up a box or something with a drop down list box that has the list of records to choose from. I also want the user to be able to type a letter and have it go to the record that begins with that letter in the list box. I...

I would like to view multiple records at a time on one form. I was thinking of doing a datasheet format for the form(rather than the columnar format I've been doing which displays one record at a time). Here's the question. Is there a way within the form to be able to double-click on one of the...

I have a form where in design view you can see the header, detail and footer. Then in the form view, the detail section is gone. The header and footer are there but the detail section doesn't show. Here's the thing, this was working last week and somehow it has decided to change. Anyone have...