Recent content by lexi0088

OMG, you are a God Send! God blease you and thank you so much! You have saved me so much heartache.

That Worked Great!! Thank you for your help. But I still have one problem, it kicks out data that has an & in it. So how would I escape these special characters?

I am trying to figure out how to create a query (or view) that will create several columns for this one column of data. The data type for this column is text (I did not set this up & I cannot change it). The column [records_XML_String] from table [WebApps].[dbo].[cm_app_xmlform_records] is...

My goal is to have the data that the view supplies available NOT in real time. When my view is called, it ties up the old server, making everything that runs on that server slow down. I would like to somehow take a snapshot of the tables in the view (or the the view itself) on a nightly basis...

I am trying to move data from one server to another, but have hit a bump on how to replicate a view I use on the old server. Due to the traffic on my old server, I had to create an independent server to hold a few tables in which 2 seperate programs use almost independantly. My only problem is...

Remou, I have thought about the autonumber situation, and that will be a step in my import. As far as making each group a row in the table... that is exactly what I am trying to do. This table is an import of a text file. My first step is to identify each group (hence the loop I am trying to...

I have a table in my database (which is a text file import from raw edi data) that I need to somehow group. I would like to first loop through the table and assign a group name to the records. Here is the example of what the table data might look like: Field1 Field2 Field3 Field4 PTD SS N1 ST...

I went through all of the code on the main form and the subform and neither one of them have a reference to the other. The only thing linking them is the parent/child which is Master Fields:INVOICEID (main form) Child Fields:InvoiceID (subform) I have to mention that I do have another subform...

I have searched through all the code and could not find anything other than it setting the invoiceid

I have a Form with a subform in it. As I enter data into the main form, new blank records get added to the subform. How do I prevent this from happening? I only want records to be added when I click into the subform. The subform has totals in it that relate back to the main form. Would making...

I have figured out part of my problem... I was refrencing this increment field in another field, which was making it increase by 2. Any reason why you cannot reference this field?

I am trying to number my rows that appear in my queary. The query actually goups and sums data, so the count function will not work. I have the following code in my module: Global IncrementVariable As Integer Function IncrementValues(QTY) As Integer IncrementVariable = IncrementVariable + 1...

PHV, YOU ARE AWESOME!!! Thank you so much, I must have tried every combination but that yesterday.

I have the following code that keeps giving me syntax error (missing operator) in query expression "[CBNumber]= 79CB". I am running Access 2007. Private Sub Command34_Click() On Error GoTo Err_Command34_Click Dim strDocName As String Dim strWhere As String strDocName =...

I am having a few problems setting up users in Forecaster. I have the forecaster database set up in SQL. I was able to add a new user in SQL and then into Forecaster with some assignments. When I log into Forecaster as the new user, there are no departments or accounts assigned. I go to open...