Search results

Okay, so I solidified with our customer that we will only be receiving 1 file for every order. That means that our problem of duplication and ordering is gone. Within each file, there will only be ONE "IH" header record and then multiple possible "ID" detail records. That said, there is no...

Duh. I had a brain fart. I figured this out. Thanks though.

My vb code, I'm asking the question about whether or not some data has been imported or not during a previous step. If it has not then I need to run about 5 tasks. if it has, I eliminate 3 out of those 5 steps. I need to know if there is a way to continue on with only the remaining 2 steps...

Thanks to both for the replies. Gemma, can you tell me what you mean that the data looks problematic? Also, I'm interested to know how you process each line individually, can you tell mea little bit more about that? Georged, I understand what you mean now about altering the file pre-access...

Also, I need to add that the temporary table does have an identity specification field (autonumber) so all records are incrementally kept track of. Not sure if this helps or not.

Thanks for the reply. I also understand the risks, but my choices are limited. I'm using a temporary table to pull the records in, then make all modifications I need on that temporary table. Then I'm writing the header records to my header table and my detail records to my detail table...

I have a delimited file that I'm importing into a table (easy enough). This delimited file contains records that need to be split into two separate tables. 1) An Order Header table, and 2) an Order Detail table. Normally this would be easy enough, however I'll need to join these tables back...

Thanks boblarson. Funny enough, I was just looking at that site. Do you know if the help under the following URL will provide me with what I'm looking for? Specifically I'm exporting a Query to excel, not a report. I'm not sure if that changes any assumptions. Let me know your thoughts...

I'm not really sure how the fields in the form would be relevant. I can verify that the data is being store properly on the tables. The datatype being used in the table is Memo. The behavior only occurs when the data is appended from one table to another or when it is exported to excel. Any...

I have an append query that takes data from one table and writes it to another. What I'm finding, however, is that it will only write the first 255 characters, and it leaves off everything else. Once in the destination table, I have fixed many of these fields so they contain the full data...

Wow! Thanks Rich. This certainly looks robust enough. I'm going to have to admit that I'm not familiar with VB code enough to know where I even need to insert my unique parameter values here. Can you help me work through this? What will I need to change on this and where exactly will I be...

I'm not actually sure this has helped me out exactly. On the query in the example file I was able to download, he refers to a table that doesn't exist in the example database. Given that, its really hard to replicate what he has. I've read up about using DSums on Queries or forms. I just...

I have a form to view inventory transactions that happen in sequence. It is sorted by the primary key which is just an autonumber field, so all inventory transactions show up in the order in which they entered the inventory transaction table. What I would like to do is add an unbound...

Are you sure? When I make that change I get the error message: Run-time error '2465': Microsoft Office Access can't find teh field "OS_Child_ctrl" referred to in your expression

This is exactly what I have now: Private Sub OS_Label_DblClick(Cancel As Integer) DoCmd.OpenForm "TransactionView_OS", acNormal, , "[OS_Child_ctrl] = " & Chr(34) & Me!ctrl_OS_Child & Chr(34), acFormEdit, acWindowNormal End Sub Its still asking me for a parameter value for OS_Child_ctrl which...

Okay, so I renamed the controls to ctrl_OS_Child on the original form, and OS_Child_ctrl on the form that is supposed to pop up. Here is the code that I now have: Private Sub OS_Label_DblClick(Cancel As Integer) DoCmd.OpenForm "TransactionView_OS", acNormal, , "[OS_Child_ctrl] = ' & Chr(34) &...

Sorry its taken a bit to reply to this. I trust you'll still be out there. OS_Child is the exact name of the control. OS_Child is ALSO the name of the data source in both instance. Not sure if this changes anything.

Still no luck. I'm not sure if you saw my last post. I indicated that the control that both forms actually have in common is OS_Child, not OS_Parent. That being the case, I just switched them out so I have this: DoCmd.OpenForm "TransactionView_OS", acNormal, , "[OS_Child]=" & Chr(34) &...

Thanks for the reply. Sorry, I haven't been too clear. "OS_Child" is a product ID in our inventory management database. From the main form, "OS_Child" lists the item along with the current available onhand of that item. I'm trying to use OS_Label as the control from which to open...

I realized I was calling the wrong control. Its actually supposed to be "OS_Child" in both instances. I changed this ,though, and its still not working, so it obviously wasn't the problem.