Search results

Thanks Dave. Unfortunately that didn't work, but I have got it to work with the following... trimmed_employee_number = Left(new_employee_number, 8) Thankfully it doesn't error with any of the other fields which are of variable length. I'll keep an eye on it to make sure I'm not losing...

Thanks - I have just tried this: new_employee_number = Trim(CStr(DDERequest(conv, cell_employee_number))) But it doesn't work and I am still getting the white space when passing the value like this: [employee_number].Value = new_employee_number The screencap attached is the error I get...

Hello people :) I've got a piece of VBA scripting which runs as an event linked to a button on my MS Access form. I maintain a database of members of staff at my organisation. It's pretty outdated... I'm basically wanting to pull in their updated data (extracted from on our payroll system)...

Sorry I'm confused... I posted some sample data above, and I don't have the query as I don't know how to write it?

I have a table called user_change an within that I record the changes that have been made to particular users. The fields I want to query are: username change_type This second one is a text field which has a value of the type of change. I want to find all of my users who've requested a...

Thanks for the explanation. I'm still a bit confused but it's not a big deal as I can live without the other data in there. Many thanks for all your help. :)

That is the subquery yes. I didn't think adding additional fields would matter? (The reason I didn't mention those additional fields is because I don't need to do anything "different" with them - just place the values into my query results.) I'm struggling to see why having those fields would...

Hmm... I've just double checked the output and I'm still getting duplicate rows from "users" for those users who have two or more entries in "user_change" which match my criteria... not sure how to resolve this one? My subquery: SELECT dbo_ipms_user_change.ipms_user_id...

Thank you SO MUCH for the very detailed and foolproof instructions (you may be able to guess I need a bit of detail for things to make sense as I am still learning - slowly)! That worked like a charm. Thanks sooooooo much!!!

It's me again, being annoying... So I have two tables: users primary key = user_id (AutoNumber) surname (Text) forename (Text) ... user_change primary key = user_change_id (AutoNumber) user_id (Number) which relates to the user_id from "users" table change_type (Text) action_date...

I need the output of those fields to be lumped together so they're easily readable... it makes sense to me, but realise it may not make sense to anyone else! Thank you for your help. :)

Hi :) I'm creating a query which pulls together the numerical values of 32 separate fields. Each field has the potential to have a value in it ranging between 1 and 9, but most fields will be blank. I want to prefix the value (if the value is not null) with a 2 or 3 character-long code...

Thanks so much guys. You have both been really helpful. I may be 2.5 hours past my intended deadline but I managed to get the query done and ready to run on a weekly basis! It's even better than I thought it would be. Happy team all round! :)

Ah gosh thanks guys. I'm going to attempt the table method tomorrow morning and chances are I'll be back with more questions as I'm VERY much a novice. :)

Thank you for that! Unfortunately just left the office so can't test it out until tomorrow morning. I'm not 100% comfortable that I know what I'm doing with the above but I'll have a go. It's unlikely that other categories will need adding to the list so I don't mind doing a function instead if...

I wouldn't have the first clue how to implement the table method so I'm intrigued... how would that be done namliam?

Thank you for your kind reply pr2-eugin. :) Sorry, I thought that giving the fields "simple" names would make more sense! My bad... FieldA = text field, max. 50 chars and it's called uuid (it should probably be changed to a number field, right, with max of 12 characters? Hmmm - I didn't...

I have no idea if what I'm doing is even possible... However this is what I'd like to do. I have a database of around 15,000 users and I'd like to create a query that I can run on a weekly basis and save the results to an Excel spreadsheet. The results need to be logical and understandable...

That did the trick! Thank you so much! :D

Thank you. I've tried that and I'm getting "Item not found in collection" now... hmmm... any ideas? This happens whether I include the "TOP 1" or remove it entirely...