Search results for query: *

Thanks MajP, the "unSelectListBox2" is what I wanted in the sense that it clears the highlight away. But can I then reset the list box so that it will go to the top of the list again, but with no highlight. Thanks

Not sure I am following this. The listbox already exists how does this clear the list box I have selected, since it seems you are deleting from a totaly different table. I don't want the list box on my form to lose any data. So how does deleting a record from another table, clear the selection...

I have read a few threads on how to clear the selected line from a list box, however non of the work. What I would like to do is if an item is selected and then I add a new item to the listbox, I either want the selection highlight to be cleared or move to the top row. The problem is after I...

Hi I have been running a script to dial into a system with no problems, now due to a change in our phone service I need to dial out using a calling card. I have set up the information into Procomm, but when I run the script it does not pick up that information. The phone number I am dial is...

Thank you very much.

I am not sure what you mean by parallels or bootcamp. I no close to nothing about Macs. Would this mean that they would have to have a dual operating system (ie Windows also installed besides the standard Mac software). Please adivse. Thanks

I have developed and MS Access scheduling program for PC's. There is a lot of VB code involved in this. Would this program be oprable on a MAC computer? Please let know, thanks for your help.

I am using an Access database to send out e-mails. It works pretty well (I am using the CreateObject("Outlook.Application") format for sending the e-mails). I want the e-mail message to be in the text body not as an attachment. I am able to accomplish all of this with one problem. One part of...

I am trying to concatenate 2 fields into one, that is no problem, but I am also trying to have the 2nd part of the concatenated field as bold, while the first in normal. This is the part I am having the problem with. Is it possible to have multiple formats in one field? Any help would be great.

I may not have followed the whole thing properly, and I have never used the dcount. I did try this so give it a shot. First I have found the using the RecordCount function if the recordset is Null then it returns an answer of 0, not Null. Second, RecordCount seems to return the count of the...

I have a continuous subform in a main form. The subform does not allow additions. I have a command button that will allow the user to add an additional item into the subform. How do I get the curser to go to the new record line. The subform is long and does not show fully, and I do not want the...

I have an unbound form with 2 combo boxes. The first combo box gives me a list of tables, and their properties. I want the row source for the 2nd combo box to use the table that was chosen in the first combo box. How is this accomplished? For example: sql = "SELECT tablename.field1...

I have set up a combo box that allows additions to the list. What is supposed to happen is that when a number is entered that is not on the list a Yes/No message box is to appear to confirm if they want to add a new number to the list. If they say yes then a form opens to allow them to enter the...

No, I am looking for a way to do it in VBA. I have a report with 3 sections. Because these sections are limited in length, I want to tell the report to start a new page and keep the same page format, if the number of items in the detail section exceeds a certain number. I have tried...

What is the proper syntax for forcing a new page with VBA? If the list of items in the detail section of the report exceeds a certain number, I want to force a new page. How is this accomplished? Any help would be appreciated.

without quite knowing all the details, you can do a iff(txtOne=1 or txtOne=2.....). Or and And statements work the same way. I have done it in the past and it works. The only problem I see if the statement gets too long sometimes Access doesn't like it.

This is the message that I get whe I open my database or use a report with a logo on it. The db seems to work fine, but this is annoying. A problem occurred while Microsoft Access was communicating with the OLE server. Try one or more of the following: - Make sure you’re connected to the...

The easiest way to do this is this: In the menu goto view and select Report Header/Footer. This will diplay these sections in you report design veiw. Copy the fields you have for the totals of each plant (Old, New, Total) into the report footer. This should work.

I did that yesterday while checking for the virus. So I have all the windows updates that are available.

Windows XP Professional