Search results

starring the incredible

I'm afraid I don't quite get it... :) Can you post the database again with the form that causes this included? Greetz, Seth

There are a few ways to do this: The dirty way The fields in your main table you want to fill in are textfields. Simply place the fieldname in the Controlsource-property of your combo. In your main table, the option the user selected will now be stored as plain text. The clean way In the...

No problemo :cool: :D

This would be a nice query to start with: SELECT Table1.SIGACT, Count(Table1.SIGACT) AS [Number] FROM Table1 WHERE (((Table1.Date) Between [Date From:] And [Date To:])) GROUP BY Table1.SIGACT ORDER BY Table1.SIGACT; Just create a new query, open the SQL-view and paste the above query into...

The error was caused the recordsource of the subform; it was a SQL-string while I had expected a queryname. So, I fixed this by creating a query from your query-string. I also fixed the loop because the way it was, it would never include the last record on the form. Everything works now...

And is this control-filling actually triggered by an AfterUpdate-event? If so, you could add the same code to the Form_Load-event. That will make the filling-in happen when you open the form. However it won't when you go to another record. A possible sollution for that might be building custom...

I understand what you are trying to do, but I'm afraid there's not enough info to determine exactly what went wrong. It says something about key-violations, so in your main-table, what field has the primary key? It seems you're trying to add several duplicate values there. If that doesn't fix...

Condoleeza wrote on

Oh... I see they are both boolean's ;) Consider posting the database, I need to see it... Seth

Lets first try to get rid of that error. Check if these fields are both Boolean (Yes/No) in your table. Forms![Orders]![OrderDSubform].Form![Available].Value = True Forms![Orders]![OrderDSubform].Form![Avail].Value = True If one of the two is a text-field, change the = True with =...

Well, just to be clear on 1 thing : You're not gonna be able to do that by using just one query... I'll think some more about it and maybe it will come to me ;) Seth

You can also use: DoCmd.SetWarnings False 'Your query executing goes here DoCmd.SetWarnings True Seth

If you don't want your fields to be edited, open your form with: DoCmd.OpenForm "Formname",,,,acFormReadOnly If you want to add a new record: docmd.OpenForm "Formname",,,,acFormAdd Just reset the settings of your field to Locked = False, else the acFormAdd mode won't work I think. Seth

who can't go

Hehe, hence the signature :)

The Evil One (inside joke)

to follow the

Why did you put your code in the Timer-event? I'm pretty sure that's causing the loops... Just place your code into the Form_Load() event of your form and replace the following lines: "On Error GoTo Err_Form_Timer" with "On Error GoTo Err_Form_Load" "Exit_Form_Timer:" with "Exit_Form_Load:"...

I would guess it's the installation... If you restarted from scratch and it still corrupts, better do a reinstall. Seth