Search results

missed this one: http://www.utteraccess.com/wiki/index.php/Recordsets_for_Beginners

http://www.techonthenet.com/access/modules/index.php

Hi, There are a few ways: 1 - if all you need is one value, use DLookup function: http://www.techonthenet.com/access/functions/domain/dlookup.php. For output of a set of data, look into (that is, google) Recordset. In Access, I find Dao.Recorset to be quite simple and fine to use. try this...

Great to hear, glad I could help!

Nz() Function: http://www.techonthenet.com/access/functions/advanced/nz.php

Hi, then check the result of Dlookup for Nulls before setting it in the control. You can use a temporary variable, and/or Nz() function for that. See if in case of null you can set the picture to "" ATB

I am (actually was;), I now use this Query without aggregation) using this field just to present meaningful data in an aggregation on it's table. I guess you'r rite: it is more efficient to join the memo field, than to compare it's value and find if it is a first occurrence... Thank you for...

Hi, I thought of your idea, but in Allen Browne's link I brought above, he suggested to aggregate the Memo field by FIRST (and deal with change of the field name), and it seems to give me fine results. Is one method better than the other? TIA!

the value of emp_ID has to be enclosed in quotes on both sides: Imageholder.Picture = DLookup("[emp_Pic]", "Employees_table", "[Emp_ID]='" & Me.Emp_IDCombo.Value & "'")

Hi DocMan, This field was a 255 bite text field, but some my data exceeded that length, and I made it a memo. Today the maximum length of text in this field is 480, the average is about 44... Is there something I can do to get it back to a text field?

Thanks a lot! http://allenbrowne.com/ser-63.html

Sorry, I was wrong! this field is the only memo!...

Thanks for replying, No.

text is gibrish in group by query Hi all you experts! while processing string manipulation on a table (140K records, 200-250 MB) the file has corrupted, and I lost all vba Modules, but the data and other DB objects seemed to be in tact. I now have a query with a text field, when I make a...

Hi, emp_id is numeric? DLookup("FieldName" , "TableName" , "Criteria = n") just fill in the name of your table, and field holding the path to the picture. your Criteria section should be something like "emp_ID = " & Me.Emp_IDCombo.Value now you can sign the result of the above to...

Hi, I assume you don't know SQL ;) If so, I recommend you learn, google SQL tutorial, there are some great free courses out there. until then, you can use Dlookup function: http://www.techonthenet.com/access/functions/domain/dlookup.php Your mind is set rite: we tend to avoid hard-coding...

Yup, you need the quotes, Chr(34) is better here: "[fname]=" & Chr(34) & Me!Fname & Chr(34) & _ " And..."

Hi, See Documentation on Dlooup: http://www.techonthenet.com/access/functions/domain/dlookup.php Seems to me Me!Fname and Me!Lname fields should be in quotes: DLookup("entered", "tblemployee", "[fname]='" & Me!Fname & _ "' And [lname]='" & Me!Lname) & "' Person already exists" & _ ", and was...

Hi, Then you would need to select the date from the table. Use Dlookup:(http://www.techonthenet.com/access/functions/domain/dlookup.php) EnterDate = Dlookup("yourDateEnterFieldNameHere", "trainingdata", "[Empid]=" & Me!EmpID & _ " And [subjectid]=" & Me!SubjectID & _ " And [trainingdate]=#" &...

Hi, Yes, corruption is an issue in access...! I have recently lost a few VBA Modules to corruption... I was testing data for a client, and thought it was a short term job, I was working on my lap-top (no network!), and haven't split 200MB of data from FE... I had to recreate some nice amount of...