Search results

Hi Hay, Glad you are ok. May 24-28th is the sunny trip to scotland. Little one is ok, started to teeth now (six and a bit months old now)..Doesn't time fly. Anyway good to talk, speak to you soon and we will drop into perth sometime soon. Take care Andy

Thanks for the info Pat and GSM. Andy

Hi Hayley, Long time no speak, how the hell are you? Answer: I think!!! ;) Don't format the filepath as a hyperlink, store it as a text string and format the text box on your form by changing the text color to blue and underline it, so that it appears to be a hyperlink visually, then either...

Hi Pat, Thanks for the reply. I currently use the transferspreadsheet command in vba to import the current excel spreadsheets, but the customer is talking about transmitting via EDI. We are setting up a project team, as this is new to us but I was just curious in what sort of format generally...

Ok, In the underlying table set the default values and the formats at table level Date Field > Format is Short Date , Default Value is Date() Time Field> Format is Short Time, Default Value is Time() Do the same on the form. When you click on the txtbox the date will just show and when...

Ghudson, That is an excellent utility for capture. Thanks for that. Always used Irfanview and other image editors. Thanks Andy

No. I am using XP Professional and don't have any probs. I converted it to 97. Do you want it in 2000? What errors are you getting now? If still no joy i will send you my email address via PM. Andy

I don't get the error message. Download the db(97 version) Here Just import them into your db. Take a look Let me know how you get on. Andy

Why would you be using a combo to display the date and time? And are you using the Date() and Time() functions as the default values? Andy

Just put TRUE in the criteria section. Andy

See the txt file attached. Just copy and paste the code into the module and try that. Andy

Try something like: Sheets("Sheet1").select sheet1.range("B2").activate activewindow.freezepanes = true Change Sheet1 to your worksheet name. Hope this helps Andy

Hi All, Just wondered if anyone has any experience of data being transmitted via EDI(electronic Data Interchange). I am wondering what sort of format it generally is transmitted in and it is something that is up and coming and I will need to amend the data import facility of my db if the format...

Ok, with your current code if you move all of the code for the cmd button and copy it into a module like this: Public Function CallButton() Your code goes here.... End Function Then the code for the sub: call callbutton This will call the whole function in the same way. You will have...

The reason you are getting the error is because you have defined the if statement, but not closed the if statements by using : End If I will have a look at the db to see if we can change the code to reduce the if statements. Andy

Hi Red, To post a db, zip up the db and when you post a new thread, scroll down the page and there is a button 'Manage Attachments'. Click on the browse button, and select the zip file , then click upload. The attachment if below 100k will display in the attachment section of the post, then...

Firstly please take my comments in a constructive way, as they are not intended to offend. One table is bad practice and design. Do a search on normalisation and db design. Secondly Queries are not time consuming or difficult.You should be using queries in some shape or form in the db. If...

Try Irfanview here It is freeware and you can capture the screen by a hotkey (f11) or by timer and it will capture the whole screen or the foreground(current window) Andy

Any chance of the db to understand the reason for the code? Andy

Sounds like you need to create a query and not a search function. You can then base the query on the report. Try breaking down your questions and solve the first part and the others will follow. Post an example if you can. I would create a query based on the fields and if necessary reference...