Recent content by bgcogen

Help me! Does anyone know of anyway that VB code can be written in an Excel application, so that it copies data from an active Query in an Access database application, and then pastes those records onto the Excel sheet????? Thanks, D

Hi. Ya, I entered it as you said: [Forms]![Site_combo]![SiteA] But instead of the pop-up form I get a dialog box saying: Enter Parameter Value Forms!Site_combo!SiteA Any ideas??? If you could send me an example it would be BRILLIANT! Thanks for your help, D dmungovan@bge.ie

Hi. I created a popup form called Site_combo an inserted a combox of all the sites called SiteA onto the form. Then in the Query in the criteria field under Sites I entered: Forms!Site_combo!SiteA. When I tried to run the Query it changed the above expression to...

Hi. I have a report that is based on a criteria query. The user is asked for machine part and site. Right now the user has to manually type in the site and then the machine part required for the report. Is there anyway for the user to be presented with a combo-box pulldown menu instead of...

Sorry but this is an Excel type question, but it's important!!!!!!!!!!! Basically I have a query in Access that has a bunch of records with dates attached to the records. I have to copy and paste the records into an Excel spreadsheet. Grand. But some dates get screwed up. The dates in the...

Well, I just want the query to show all the records between the ones that the user entered at the prompt. It was my understang that what ever was between the brackets "Between [] And []" would appear on the message box to let the user know what to type. The Master table contains hundreds of...

Hi. I have a query that is drawn from a master table. In the query there is a field for date. In the field for date I have it formatted as: Date: Format([Time of fault],"Short Date") Grand. But when I put: Between [Start Date dd-mm-yy] And [End Date dd-mm-yy] into the creteria field to...

Hi! Quick question. I have a .bat batch file that performs a task. Is there anyway in an Access form to activate the batch file when a button is pressed. I tried OnClick in Event by can't find an option for a .bat file. Thanks, D

Hi! Basically I need to know the VB code behind a form that adds one month to a certain date. So the user types in a date into a date field, and then in the code behind the Form I want it to add one month to that date and save it in the table. Does anyone know how this can be done...

Hi! Basically I need to know the VB code behind a form that adds one month to a certain date. So the user types in a date into a date field, and then in the code behind the Form I want it to add one month to that date and save it in the table. Does anyone know how this can be done???? Thanks, D

Hi! This is my boggle: Basically I have a form that the user input into. They input 3 fields. E.g. Incident Type, Site and Date. Grand. I want to create a report based on a creteria query that sorts the data based on date. So the user inputs a start and stop date and all the records betwen...

Hi. Any ideas anyone: Basically the user inputs into a form when they did a particular site maintanence e.g. "Did monthly left engine check on 12/6/02". The user inputs this weekly/monthly/bi-monthly etc data into a form when they do it. All that's grand. I want the database to create a...

Hi! Kinda of an Excel type VBA question, sorry!! Basically I have a string array declared as: Dim MyArray(5) As String MyArray(0) = "BG1" MyArray(1) = "BG2" MyArray(2) = "BG3" MyArray(3) = "BG4" MyArray(4) = "BG5" Anywho, in the code I need to loop through a particular...

The Array is holding a group of 6 strings. The calculations are just for changing the values in cells. D

Hi. This is a VBA program in Excel, but I hope someone could still help me??!! I've got an array that contains 6 Strings. I declare it as follows: Dim MyArray As String MyArray = Array(BG1, BG2, BG3, BG4, BG5, CP1) I also have a block of code that performs a certain task. I want...