Hi Jforbes,
Turns out, i was looking at the wrong field in the criteria part of the query...solved it!
Thanks for your help, it was much appreciated!
Pierkes
Pierkes
Last Activity: Sep 10 '15, 06:11 AM
Joined: Feb 4 '13
Location:
-
Hijforbes,
Problem is not an error message but no records returned.
I'am not being asked a parameter when running the query,, the form is running, the field is filled.
I did not use a ? Nor do i know what you mean by this....can you explain a little more?
Thanks,
PierkesLeave a comment:
-
Query criteria based on string in a text field
Hi,
I have a query in which there is a text field called "name"
I have a form with a textfield called "name_clien t" in which the user can put in the (part of the) name of the client.
In the criteria part of the query i have;
Like "*" & [forms]![frm_client]![name_client] & "*"
But it will not filter on any part of the name of the client.... -
Hi zmbd,
Turns out that i was looking in the wrong place....ouch !
On the frm_traject_det ails form i have a button to close the form and go back to the frm_trajecten form.
This was the code;
...Code:Private Sub cmdClose_Click() On Error GoTo cmdClose_Click_Err On Error Resume Next If Me![Status Res] <> 5 And Me![Soort traject] < 6 And Me![chk_reden]Leave a comment:
-
Hi zmbd,
Tried your suggestion but i do not get an error message when starting the form frm_traject_det ails.
However, i saw that when the frm_traject_det ails is opened, the main form frm_trajecten is "locked" or "not accassible" the form's name tab is less highlighted, indicating you cannot work with the form.
When frm_traject_det ails is closed, frm_trajecten should be accessible again, but...Leave a comment:
-
Hi Twinnyfo and ZMB,
Thanks for helping me.
I changed the code with your suggestions ZMBD and it now looks like;
...Code:Private Sub tr_naam_traject_Click() On Error GoTo tr_naam_traject_Click_Err On Error Resume Next If (Form.Dirty) Then DoCmd.RunCommand acCmdSaveRecord End If If (MacroError.Number <> 0) Then Beep MsgBox MacroError.Description,Leave a comment:
-
Hi Twinnyfo,
Thank you very much for replying. Tried your suggestion and it now returns from the frm_traject_det ails to frm_trajecten but the the program does not react to anything anymore.
The only thing i can then do is stop the program and restart it...
Any suggestions on how to proceed?Leave a comment:
-
Form Does Not Return when Changes Made - Instead Locks up Database
Hi Twinnyfo,
Thank you very much for replying. Tried your suggestion and it now returns from the frm_traject_det ails to frm_trajecten but the the program does not react to anything anymore.
The only thing i can then do is stop the program and restart it...
Any suggestions on how to proceed? -
error opening form based on record nr.
Hi,
I had an embedded macro that i converted to VBA code...now, it does not work anymore...
My situation:
I have 2 forms;
- frm_trajecten - list of clients
based on a Query: Q_trajecten which is based on a table tbl_trajecten
- frm_traject_det ails - details of a client
based on query Q_trajecten_det ails which is based on table tbl_trajecten
in tbl_trajecten... -
Pierkes started a topic How to set focus to a field on subform which is placed on a tab of the mainformin AccessHow to set focus to a field on subform which is placed on a tab of the mainform
Hi,
I have a
- mainform called: [frm_traject_det ails]
- a page on the mainform called: [page_status - resultaat]
- a subformelement (for displaying subform) called: [Redenen van winst of verlies]
- a subform called frm_reden
- a combobox on the subform called: cmb_reden_cat
When a certain criteria is not met, i want to show a message and set the focus to a field on... -
Hi NeoPa and others,
I was playing around with my code and found something interesting...
Wit combobox [cmb_reason_sele ct] I use column 1 as bound column. I have 4 columns with a width of 0cm;4cm;0cm;0cm
Now, I tried to let it see one extra culumn, so ; 2cm;4cm;0;cm;0c m
This way the bound column is NOT 0cm wide. (I tried changing the bound column to a different column but that didn't do anything)...Leave a comment:
-
Hi NeoPa,
Thanks for your reply. However, i do not know how to do what you suggested.
Could you give me some more direction on how to, every time I need to set the SQL up originally to filter on the ComboBox by reference ?
Thanks in advance !
PierkesLeave a comment:
-
Hi Twinnyfo and jforbes,
Tried your suggestions but somehow i cannot get it to work.
I try to explain what happens;
The first combobox(cmb_re ason_type) works fine, also when i have multiple records. It will keep its value record by record which is good, no problem there.
However, when i enter the form, the second combobox (cmb_reson) will show empty (which, when i leave out the code in the FORM_CURRENT()...Leave a comment:
-
Hi Twinnyfo,
Sorry, didn't work at all. All it did was mess up both comboboxes.
Any other suggestions ?
Best regards,
PierkesLeave a comment:
-
use one combobox to fill another in a subform...
Hi there,
I have a problem with a subform on a mainform.
I have;
Databases amongst which;
tbl_trajecten (including field: ID_traject)
tbl_reasons (including field: ID_reason_traje ct)
a main form called : frm_traject_det ail
a form called : frm_reasons (which is used as a subform on the main form using ID_traject as linking master field and ID_reason_traje ct as linking... -
Hi Jimatsqi,
Thanks for your help. I reviewed it myself and took a different approach....
I made an extra table called tbl_wishes_dbas e and us that to store all wishes of a client in a subform on the main form.
A report is then much easier to create for all wishes.
This way i can make it much easier.
Thanks for your help though !
Best regards,
PierkesLeave a comment:
-
use of query makes report very slow
Hi,
I have a report which uses a query [Q_rap_reports] to generate the records. The query base is a table called [tbl_records]. In the table are 10 fields registering the whishes of the client called [whish1] through [whish9] that all use the same query to find te corresponding item [Q_whishes].
I started with 2 fields to link to the same query (added the query 2 times to generate the report query). This worked fine... -
Hi Twinnyfo,
I managed !!!
I had the bound column for the combobax wrong. I set it to column 3 an it worked !
The code is now very simple;
Thanks for your kind help !!Code:DoCmd.OpenReport Me.cmb_rap_rapselect, acViewReport
PierkesLeave a comment:
-
Hi Twinnyfo,
Thanks for helping me.
The only code i have left now is;
However, now it gives an error because "the action or method requires a Report Name argument"Code:DoCmd.OpenReport Me.cmb_rap_rapselect.Column(3), acViewReport
Any ideas ?
Regards,
PierkesLeave a comment:
-
Hi, I now have this code;
However, it does not open the report. It gives the message that it cannot open a report with the name 'Code:strSQL = "SELECT * FROM Q_raps " strSQL = strSQL & "WHERE [Rap_select] = me.[cmb_rap_rapselect].Column(3)" DoCmd.OpenReport strSQL, acViewReport
...Code:"SELECT * FROM Q_raps " strSQL = strSQL & "WHERE [Rap_select]
Leave a comment:
No activity results to display
Leave a comment: