Search results

here is a screen shot of the design,,

you mean where I put the code.. Private Sub PageFooter1_Format(Cancel As Integer, FormatCount As Integer) With Me .txShpAcct.Visible = (Me.Page = Me.Pages) .txtAgtCar.Visible = (Me.Page = Me.Pages) .txtCarAgt.Visible = (Me.Page = Me.Pages) .txtCarShp.Visible = (Me.Page = Me.Pages)...

Dcrake, here is a stripped down file, I have to hide all the data so I over wrote with X's and the few that are left are over writte, but it can be any file any content for an example. ISA*00* *00* *01*xxxxxxxxx *12*xxxxxxxxxx *xxxxxx*xxxx*U*xxxxx*0xxxxxxxx*0*P*>...

I'm using this right now in the format event... me.txShpAcct.Visible = (Me.Page = Me.Pages) but it still leaves a Blank space, where the Page footer controls would be. I've tried setting the controls to shrink/grow but it doesn't matter. I can manually set the footer to be invisible in the...

i came up with a different method to get my data, which has nothing to do with what I requested....I was able to use the existing data by modifying the field length so thge message I was looking for would not get cut off..... Gemma...that would not have worked because I don't know the file...

thanks Guus2005, I didn't see your reply when I clciked on "userCP". I will see if it works for me.

I'm mulling around some idea's and not too sure which direction to take. I need to bring some data into my database, they are text files (actually EDI X12) standard) but I need to figure out which file is related to the record. How a can I search the contents of a file ( in a directory) to...

FYI - I put this together and it is working, it reads the field with the qty and adds a record for each. My next step will be to make a report based on that table. and then add it as a sub report. what I will do is make this happen when I run the report and do the update only for the selected...

I am using just a rectangle shape, sorry it is not a control...basically if I had the report designed with one shape I want to be able to repeat printing the shape in the detail section I would want to say calculate that I need 6 boxes for the item and then have Access repeat that control 6...

I have a report that serves as a receiving form for the warehouse, we know all the "Expected" info, so I have all the header and product details filled in. The Warehouse needs to manually write down where they put the stock, so I place X number of empty text boxes to form a grid for them to...

did you check the security settings? Make sure it is not too high or you won't be prompted, and some things won't work.

Not sure why it is urgent, either you use them or you don't....I think there is another way to bring up the dialogue, but this is how I do it: Start to Import a text file ( you won't complete the import), when you get the import wizard, click the advanced button...here you will see the list of...

hi Sviggos, I missed the notification that you replied...hope it is working now...for your question, in theory it should work. if you explain which field and by what value, I can check it out. also, I thought I'd mention a better technique for passing criteria to the query.... eg this...

that's fine if you only have to do it once in a while, but that is why you can save a Specification template in the Access wizard. Once you have defined the data types, it will work seamlessly in an automated process.

your asking for query help, but it sounds more like Form help...it would help to see an example...removed Personal data....if I were to guess, it sounds like you want to link the ID of the Family table to one of the sub forms...if so then you need to link the Family form to the other subform...a...

Try this.... ActualElapsedTime: Int([StopActual]-[Start])*24 & " hours " & Format([StopActual]-[Start],"n"" min ""s"" sec""") heres another way... ActualElapsedTime: DateDiff("h",[Start],[StopActual]) & " Hours " & DateDiff("n",[Start],[StopActual])-DateDiff("h",[Start],[StopActual])*60 & "...

I'm thinking that because you want to list the previous exports, you would need to create an export table that will hold the records that you have and want to export. You would include a date/timestamp field to show the record is transferred to the table, and then another 2 fields for a Export...

I just took a quick look. The Sub report is bound to this query... 02-ORDERS_Paid_QUERY In that query you have this field... [08-ΠΑΡΑΓΓΕΛΙΕΣ_ΠΡΟΚΑΤΑΒΟΛΗ].[ΑριθμοςΠαραγγελιας] Which I am not sure if you were in the process of renaming, but it has an empty criteria bracket [] I deleted the...

look HERE I have a working example, if you get stuck. You need to change the code from XLS to TXT and transferspreadsheet to transfertext. also when importing a Text file you need to create an import SPEC. When you manually import with the wizard, click the advanced tab and SAVE the spec...

it would help if I see a copy, make sure to remove any personal data. Don't worry about translating, I think I can get past it..except you will need to translate back to Greek any table/fields you mentioned in english