Search results

Hi, Is it possible to have two timers on the same form. I have a form where a label is turned On and Off by a timer event. But I would like to add another timer event to close the application after a specified period. Thanks, Bob

Hi, I have a combo box on a form that I created from the wizard. The box shows two fields, the Asset Number and Description. Upon selecting the Asset/Description the associated record opens in a subform. This is good, but after the record in the subform opens the combo box now shows only...

Hi, I have a form with a subform in it. I want to double-click one the the fields in the subform (PurchaseOrd) and have a tblPurchaseOrder2 form open to that particular record so I can edit a value in the record. (The value in the subform that I want to edit is based on an expression from a...

Hi, I work alot with Access, Excel and SAP. Especially with reports. I've posted here and received alot of great help and deeply appreciate this forum. My question is, I am trying to get some experience, to broaden my scope (and please the boss) and get into Impromptu reports/templates to...

Hi, My IT Group is telling me that it is possible to install both Access 97 and Access 2002 on the same computer. I say no. Who's right. I have Office XP on a LapTop I'm using for a special project and I've created a db in Access 2000, but I saw later, that it would let me create in Access...

Hi, I've been searching high and low and can not find the Image/Pic file used in the "Command button" - "Picture" property. I would like to use an image elsewhere and thought it would be easy just to copy / paste the image. But cannot locate the folder where they reside. Anyone know what...

Hi, I've an app that I would like to use a particular font for the forms. A font I'm sure is not on other computers that will be using the app. Is there a way to install a particular font in the person's computer when they open the application. Thanks,

Hi, This may sound strange but.... I have a textbox control that will not accept focus in run mode, but will accept focus in design mode. Not locked, is enabled. Have removed and reinstalled control, renamed it, moved it inside the procedure, have compacted/repaired db. Can not get it to...

Hi, Not sure what is happening here. When I try to Compact and Repair the database, I get "Table 'TempMSysAccessObjects' already exists." The table doesn't exist in the database, at least I can't seem to fine it. Could it be located elsewhere. I really need to Compact and Repair before...

Hi, Frustration is running high this morning. Need help in understanding why this happens. The code will SetFocus on the first IF and the following ElseIF, but produces "You can't reference a property or method for a control unless the control has the focus." on the remaining. My code is as...

Hi, Could someone help me with filling a textbox. I would like to have the text box accept only 6 digits. This I can figure out. But there are times that only 5 digits will be input and when this happens, the first position needs to be a "0". Example: 39315 is input, but needs to be...

Hi, Is it possible to have a vbCrLf inside a string. What I'm trying to do is have one string print out as such: Amex Number 1234 1234123 1234 Mr. Robet Jones 123 Anywhere St. City, ST 19111 thanks,

Hi, I have a form that will create an email of the form info in Lotus Notes. All is well with the form, and it opens Notes with the all the fields filled in, and is ready to send. What I would like to have the form code do also is "Send" the email in Lotus Notes without interaction of the...

Hi, Not sure this is possible, but would be nice if it were. I'am sending a report, and all is well, but would like to add a string to the [MessageText] that would essentially be the following. "The Status of you Service Request:" and then a carriage return and add the field data of the...

Hi, I've managed to get a report into Lotus Notes as an RTF format. I have a button in a form that will send a report to be emailed. Clicking the button will launch Lotus Notes and attach the report as a RTF doc attachment. What I would like to do is have Notes open and the report be there...

Hi, I'm sure this is probably one of those dumb questions, but I can't seem to figure out the right switch to set. I've started a new db and it's producing errors for any event I create in a form. Even tried to create through the wizard an Add New Record button. It even produces an error...

Hi, Not sure on how to proceed and would like your advise. Running W2K, Access 2002, Lotus Notes mail I have a form that I would like to email via Notes. I've tried the various formats but none present the form as viewed in Access. There is an option to send as an HTML Templete. Would...

Hi, Not sure if I'm going about this the right way. But I have a database on a Groups server that 10 - 15 people can access. It is set to open with a switchboard so the few forms and reports are accessed this way. The database is used to create, administor and track work orders in a...

Hi, Could someone point me in the right direction for Access 2002 and the web. I currently have a 2002 database up and running, but got to thinking that it would be interesting if I could put the one form that creates the Work Order on our Intranet so all employees could create an Order...

Hi, Been searching, but did not find a reference for the following. I'm using Access2002, but shouldn't matter. My switchboard has a list of items, two of which appears on multiple screens. One is "Return to Main Menu" and "Exit Application". What I would like to do is have these two items...