Search results

Hi Minty; The actual date field isn't called 'Date'; it is just simply called: date, I put the quote marks to highlight my field name to this forum. apologies for the confusion. so my main field that gets populated from the date picker is called: Date and the other bound fields are...

Good Morning All; I have a field on a bound form called ‘date’; that has a date picker associated to it; this populates an unbound textbox once the date has been selected. What I need to do is; once the date has populated the unbound textbox; is to populate a bound textbox field on my form...

Hi Isskint; This works perfectly and is exactly what I am looking for. :D Thanks so much for your help on this, it is very much appreciated :) Kind Regards Tor Fey

Hi Isskint; Thanks for the reply, unfortunately; I don't know what the code is to carry out this kind of validation check, are you able to help with this? Regards Tor Fey

Good Morning All; I have a form (frm_check_table) bound to a table (tbl_check); and on this form I have 3 bound fields (check_name1, check_name2 and check_name3) and one unbound combobox (called: checktype) which takes it values from tbl_check_type. What I need to do is select the data...

Ah, I see, unfortunately this won't work as I only want to show 'No Value' should the fields on my form have no data entered in to them. Most of the time they will; and the code: Expr1: Forms!frm_Postcharge_main!m_surname_send, will then append this code to my table, what I need is some criteria...

HI CJ; Thanks for the reply; is it just a case then of entering: nz(myValue,"No Value") in the criteria field of my append query? Kind Regards Tor Fey

Good Afternoon All; Is it possible to have an append query enter some default text in a table should the original text on a form be null? For Example: My Query has the current criteria: Field: Expr1: Forms!frm_Postcharge_main!m_surname_send Appending to: word_m_name_send (on...

Good Day All; I have the following code running in Access 2003, I use this code to open MS Word 2013 documents; which works well, but is there a way to amend this code; so it would allow me to mail merge certain fields from a form in Access 2003 to Word 2013? Private Sub Command0_Click()...

Resolved: Added 3 fields to form frm_EC_Main as follows: · Useris – unbound combobox linked to tbl_post staff bound to column 2; with a default value of =currentuser() in the following way: SELECT tbl_post_staff.post_staff_id, tbl_post_staff.post_staff_user_id...

Good Morning Burrina; Sorry about this, but I am new to access and have inherited a lot of old database created using vba only. I have created a table called "tbl_post_staff" in the database which contains the network id of the user (e.g. jblog) I have called my field for the network id...

Something like this would be good: if me.useris = jblog then me.officeris = Joe Blogs Can I just do it on form load with VBA? :banghead:

Can't see to make this work, here is what I have onload event: Me.currentuser = DLookup("[post_staff_user]", "tbl_post_staff", "[post_staff_officer]='" & Me.officeris.Value & "'")

Apologies; the field "post_staff_user" is the user id Regards Tor Fey

Yes; the table structure is as follows: post_staff_id, post_staff_officer and post_staff_user The field "post_staff_officer" contains the user full name Regards Tor Fey

Hi Burrina; Thanks for the reply, I have added this to the onload event of my form, although it works, it only shows the user id, is there a way to convert this to the user full name by comparing the userid in the tbl_post_staff and changing it? for example: if user id = jblog then...

Good Morning All; I have a table called tbl_post_staff, within this table I have an id number (autonumber), user id (text) and user full name(text). Then I have a form called ec_main with a combobox linked to tbl_post_staff, but stores its value in a field called officer_is in a table...

Hi Skipepl; The form field I am defaulting text to is unbound, and would only update the main table when an append query is run from the update record button, so the way I have set this form up has no real consequence on the database as a whole, as it isn't adding records until the update...

Thanks for your reply but after thinking about it, I have found the solution as follows: Private Sub Form_Load() If IsNull(w_text1) Or w_text1 = "" Then w_text1 = "Significant amount of revenue at risk 1)<50k, 2)up to .5mil, 3)up to 3mil, 4)up to 5 mil, 5)>5 mil" Else...

Good Morning All; Is there a way to add default text on a form when it loads via vba? I have a form (frm_add_targets), which has 15 fields on it and I would like to add default text to these fields if the field should be null. For example: one of my form fields is called: w_text1 and...