Recent content by millercj

Awesome, Thanks!

How would I get all the data in a Table's specified column and save it to a variable delimited with a ";"?

this is cheating but this is what i did If Run = 1 Then current = [Forms]![Comparison]![1] ElseIf Run = 2 Then current = [Forms]![Comparison]![2] ElseIf Run = 3 Then current = [Forms]![Comparison]![3] ElseIf Run = 4 Then current = [Forms]![Comparison]![4]...

yes but with one problem...it only works for the first itteration Dim Count As Integer Count = [Forms]![Comparison]![Count] Dim Run As Integer Run = 0 Do Until Run = Count Run = Run + 1 MsgBox (Run) MsgBox (Forms!Comparison(Run)) Select Case Forms!Comparison(Run) ... Loop it...

None of the data that runs in the form uses any tables. I just need to know how to call a variable field name. Attached is a screen shot. The first combo box is named "1" and the second, "2". I want the loop increment variable to be the field name for example: Select Case...

I'm trying to get data from one of 5 form fields through a loop but i'm having trouble accessing the field with the variable Dim Count As Integer Count = [Forms]![Comparison]![Count] Dim Run As Integer Run = 0 Do Until Run = Count Run=Run+1 Select Case [Forms]![Comparison]!Run ... Loop...

I'm trying to change the height of a form. The most reliable info i've been able to find said to use DoCmd.MoveSize My code is DoCmd.MoveSize , , 3200, 2440 but i'm getting and improper arguments error...any ideas?

Neither actually; the form. I want a box aside of each record so the user can either select or deselect each record. I also need the names to be dynamic because there may be 5 or 500 check boxes needed but i need to reference their values in VBA...hopefully that helps

I need to generate a form from a query which I have done via the wizard. My problem lies in the fact that I need each to have a checkbox (not fed from the query) in the form. This check box will display for each of records but the problem right now is obviously that they all have the same name...

Is there a way to list query results in a form? One line per record. I want to list them (by name) each with a check box aside of them. When a command button is clicked it will send the email addresses of all of those who's check boxes are checked to an outlook email? How should I do this?

I used the security wizard

I tried to add user names and passwords to my access database and now all of my databases that use access are password protected! How did this happen and how do I remove all user permissions from everything and start over?

Hi all, I'm trying to import a series of csv files with the TransferText function. It works fine but I'm trying to make it so the user can browse for a file. I've done such using an activex control and it successfully throws the directory and filename into a text box. When I click my import...

See attached MDB

No, it's cause i'm new and I can't post them till i've hit 10 posts. Go to the URL www dot recorded-live dot com slash table dot pdf