Search results for query: *

I have a program that imported an XML file and creates the separate tables for each of the elements. The code goes something like this If UCase(Right(fileI.Name, 3)) = "XML" Then lbltxt.Caption = "Importing File " & ofName DoEvents...

This weekend, I installed Office 2010 choosing to only keep Access 2003 installed. Not thinking and rushing, I removed the old versions of Outlook, Excel and Word. The proble is that my code in Access 2003 requires the 11.0 Outlook libray, and I only have 14.0. I tried moving the 11.0 file...

Thanks for the response. I am definitely getting closer. I did the replace and the <br /> was replaced with a square symbol(the carraige return). The problem now is that it prints the data with the symbols, rather than the actual carriage return. This all prints on one line in an Access...

I have a text field which contains a gift message. The data has "<br />" in the data which needs to be converted to a carriage return. There could be up to 5 of these within the field that need to be converted. I tried a replace, not knowing what to repalce it with. I tried & vbcrlf & told me...

I have a a client that will be sending emails(many) with a PDF document attached to it. My intention is to set up a rule where if part of the subject is a specific word, then it should print the attachment. I was wondering if someone has done this before? I did not see anything in the rules...

I want to set the value as a string rather than a number. I set up the following module _________________________________________ Option Explicit Public txtAccountNo As String txtAccountNo = "8610" _________________________________________ I get a response "Invalid Outside Procedure". I am...

How do I assign a variable globally so it is recognized on every form in the database. My users work under a specific account and I want each form to remember that account until the user changes the account. The plan is that when the user goes to the main screen, they will select the account...

Thanks everyone for your help. This worked really well.

I have a table that has two fields(Order number and Sku). There are 2 orders (133 lines and 171 lines) in the table. I need to grab the first 10 sku's from each order, and write it it a new table. I tried a "For" statment and that has not worked well at all. Any suggestions?

The field in the sequel table does not allow nulls. I am hoping not to change this as I am not sure if that would efeect the stored procedures. Once the stored procedures are run, the information is placed into another sequel table whcih I can then edit and actually use the double quotes. Here...

We recently upgraded to Sequel Server 2005. On the last version, I would write data to a table. If the field was blank, I would use an if and isnull statement using double quotes in the field so sequel thought there was something there. In the new version, it will no longer allow me to use the...

I am running Symbol MC-9090 WM mobile devices in my warehouse connecting to our server via 3 E Genius access points strategically located throughout the warehouse. The issue I am running into is that the device is not finding the strongest point for its signal. The net result is that the...

Thank you very much! The solution worked perfectly.

I just installed Windows XP Pro on a new computer for a user in my office. When I went to install the printers (creating a port in local setup). I have the user set up with administrator rights, but they cannot add printers, and other functions available to the administrator. Is there a way...

I have a text field in a table where I need to find where the first lower case occurs in the string. I am trying to create a bar code of the field, and there needs to be a plus sign before each lower case letter. For instance, the value DsMldGnRR would need to have a + sign before the "s"...

This may sound wierd, but I am having a problem entering text in VBA. When I start to type the text, the color of the text turns red as I am typing indicating something is wrong with the code. Normally it only happens after I am done, and it checks the syntax. It is almost like it is checking...

Thanks everyone for your help. In the end, I added the pipe to each field in the table. I then exported the file as comma delimited to a file. I then imported the file back in telling Access that the delimiter was now a semi colon. this put all the data into the first field. I then removed...

I placed this in the wrong forum, so here it goes again. I have a table with unique lines that have 'pipes' as the delimiter already built into the fields.Now I want to export the table to a text file without delimiters. I can not use a specification becase I must have something for a...

I have a table with unique lines that have 'pipes' as the delimiter already built into the fields. Now I want to export the table to a text file without delimiters. I can not use a specification becase I must have something for a delimiter. How can I simply export the data to a txt to csv file...

Thanks! That was perfect. I was missing the criteria section