Search results for query: *

Thanks JohnYingling. Steve and djsiders, this design is being used as a last resort - the client requires a report in a very particular format with variable columns and rows each time the report is generated. I have had to generate the table in Access and then send it to Excel to format in order...

I need to delete the whole table because each time I run the process, there is a different number of fields. I have four or five fields that are always there, however the number of fields that are added to the table each time the process runs is different. Hence I cannot simply delete all rows...

Hi All, I am developing an application which has a VB 6.0 front-end and an Access 97 backend. I use a Shell command to execute a macro in Access which: - deletes a table named SCHEDULE_STAGING - copies SCHEDULE_STAGING_TEMPLATE and pastes it as SCHEDULE_STAGING After that macro is run, I use...

I seemed to have worked things out, thanks anyway! Probably too long-winded to explain! I have had to do things a weird way due to the weird design of the database. If you draw a line control on a report and click on it, there is a "Top" property.

It must be the code I have surrounding it. You see, I want to reset the "Top" property of some controls if the value of a text box is Null. I can't ascertain the value of the text box unless it is in the Detail_Print event. So, what you suggested about putting that particular statement...

Hi, I am trying to set the "Top" Property of some text boxes, labels and lines in an Access report in code at runtime. I cannot seem to be able to actually change the property. In the Detail_Print area of the code, I have put: Me.txtAcc2.Properties("Top") = 9116 I tried a...

I was wondering how I can group a number of text boxes and call them one name - e.g. have two text boxes named "txtName" and "txtAccountNum" and be able to have those text boxes under some sort of control named, let's say "AcctDetails". I could then have code to the...

Thanks so much everyone! PaulF, that Add-In worked like a charm! You are my hero! :o)

I am modifying an Access DB and I need to change all references to the word "Consultant" to "Adviser". This word is in many field and table names, plus about 50 queries and 20 reports rely on this data. My question is: Is there any efficient way of going through a database...