Search results

  1. M

    Get all data in a column

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

    Help on variable to call form field

    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...
  3. M

    Change Form Height

    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?
  4. M

    Check Boxes in Query form

    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...
  5. M

    Query Results in Form

    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?
  6. M

    Security Problem

    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?
  7. M

    Import with variable filename

    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...
  8. M

    Access Query Limit

    Is there a limit to how much a query can analyze? If so, is there anyway to expand that? I need a way to query a table of about 170 fields with a condition similar to this IIf([Forms]![Search]![StrideG]=True,True) Or IIf([Forms]![Search]![StrideG]<>True,True) Or...
Back
Top Bottom