Recent content by merry_fay

Apologies, I'm not very good with posting...:o My_Field NumberA NumberB TSM_XYZ_ORT 24326591 6275.77875 TSM_FAB_ORT2 25259030.81 4680.243 TSM_XTDC_DBA 4161551.97 1286.26974 TSM_XXX_DB2 417607.03...

This is a sample of the data: My_FieldNumberANumberBTSM_XYZ_ORT243265916275.77875TSM_FAB_ORT225259030.814680.243TSM_XTDC_DBA4161551.971286.26974TSM_XXX_DB2417607.0378.28114488TSM_XYZ80881.108246.4329725 I want the My_Field (not a primary key) field to end up with XYZ FAB XTDC XXX XYZ It...

Ahhh, that is probably where my problem lies then. I was thinking it was an inbuilt VBA function..... (all google's fault ;)) Re-hash to my question then, how do I do a find & replace in VBA on a table? Thanks

Hiya, Unfortunately I can't seem to find examples of how the find & replace works in VBA so please can someone help me finish my bit of code! Situation: A number of tables are imported with the My_Field column having items such TSM_usualtext_blah Blah could be anything. All the other...

I'm using access 2003 but it's not the code/macro settings being disabled as all the other events are running fine. It's on GotFocus. Yep, I looked at the properties window, clicked on the 3 dots, several times, check all the words, scratched my head etc etc. I'm really confused!!

Hi, I'm trying to run a 'GotFocus' event on one of the text boxes on my form. Here's the code in progress: Private Sub txtCINAME_GotFocus() MsgBox "got focus" End Sub When I click on the text box, it's not running at all!!!!!!!! I've tried adding a GotFocus event to other text...

Solved -I put an after update event on the percent text box to save the record :-)

Hi, This is difficult to post code for as it's involving lots of different calls & events so I'll try & explain: I have a form which has a combo box (source field: [SName]) to filter it. Users can then make changes. The combo box has an AfterUpdate event for: strComboSelection=me.combobox...

Taken a while to get a chance to look at this again... But yey, it works!!! I'll remember that DMAX one for future use too. THANKYOU :D

Thanks. Unfortunately it hasn't though -I think my database has gone mad!! I even tried inserting columns so none of the named ranges started on cell A1. I've written many databases over the years, normally using the export bit in code without using a named range in the code -do the export...

Yep, I know it's faster which is why I wanted to do the query instead of code. Always good to re-iterate it though -I've used code for ages & only recently found out queries were quicker!! :o:D I am only trying to delete from one table. tbl_Act_Date is a control table with a single record -a...

Hmmm, got the distinctrow in a delete query from one of the online help sites.... Guess they don't always do everything right then!! :eek: I've given up on a query & stuck it in my code instead, setting my single field as a parameter (if that's the right work) in the code. Works that way :D...

Hiya, I'm trying to export some data to excel. I have a 'subquery' which is joining 2 tables with about 6/7 fields each then 'union all' to a different 2 joined tables with about 6/7 fields each as well. This 'subquery' is then used in a crosstab query which is joined with 1 other table...

Hi, I really am having a bad day today. I'm having problems with htis delete query too: DELETE DISTINCTROW tbl_Actuals_FC.* FROM tbl_Actuals_FC, tbl_Actuals_Date WHERE Mth >=ActDate; Mth is a date field in tbl_Actuals_FC, format dd/mm/yyyy ActDate ditto for tbl_Actuals_Date but this...

Hi, I'm about to burst into tears & throw my laptop out the window. I have a form which shows data from a table. There is a sum cell on the form: Sum([CPU New]) (CPU New being a field in the source table) After I change the value of one of these numbers in the form, if I then immediately...