Search results

I have a query where on an IIF result a field is displayed or an "OK" I have an imported field of 6 chrs where I only want the left 5 so I use Loc:=Left([Location],5) , I then compare the result in, MoveTo: to another fixed field [PreferLoc] MoveTo: IIf([Loc]=[PreferLoc],"OK",[PreferLoc]) I...

Copying Forms / Code Thanks Paul, After reviewing the MS link, I can see I am not alone !! many thanks for your prompt reply Steve

Copying forms complete with code? Access 2k Can anyone advise why when copying, exporting or importing into any of my DB, any forms containing code, I get the following "Network connection may have been lost" etc. error box. I have had this issue for years and have always worked around by...

Go to Control **Cancel** Sorry dont know why I used a macro in the first place, I have reproduced the action in VBA and it works fine, stii wonder why it worked sometimes and not other in a macro though Steve

I use a macro to check if a field xxx has been entered if not a message tells the operator to enter detail and sets the focus back to the empty xxx field. This works fine sometimes but other times it returns and error stating there is no field named xxx in the current record, why would this...

Many thanks that did the trick Steve

Action at Set Time Many thanks for the reply but I seem to have a problem with the "and" in the statement. Rather than adding time to my Backup time I just have another field Me.ReOpen pre-set to whatever time I default it to Its the and format which causes me trouble as Access declares a...

I wish to close my DB at a certain time at night and am using this very simple code but it only work on the exact time, can someone advise how to implement a between time I have a hidden form which opens with the DB and uses a timer event to run this code Private Sub Form_Timer()...

I have some data which is sent from my DB using send object this works great but only once ! if I select another record the send just fails does nothing. I know that by closing my DB and reopening all is well again its as if something is making the code hang and closing resets this any advise...

Problem Solved Sorry to have been a pain but I made a stupid mistake and included things in the detail section of the report that I should'nt have all working fine now Steve

I have a report with sub-report embedded in it, my problem is that when printing or previewing I get a copy of the report for each entry in the sub-report. i.e. The report main data has 3 entries linked to it and these show in the sub-report but 3 copies are produced. there is 1 to many...

Thanks for the reply but Im not quite sure what you mean, my ref feild is an autonumber field, I can create a search tex box on the form and I would like to do is select the new text field, scan the barcode into it and the code behind the text field search against my [ref] field and pull the...

I can use the search function provided within Access ctrl-F etc to search my data by my reference field [ref] and this will pull up the required data. I can scan my barcode to feed the built in search form field with the required data but I would like to be able to get my operators to a...

Thanks!! Just need that kick in the right direction

I have 8 tables which I need to count the records in, I want to display results of the count on a form, I have a method which seems very long winded and I am sure there will be an easy solution in vb that one of you helpful people will advise ? On a Form when opening I need; Table 1 =...

Great, and thanks for your help I now understand just where I was going wrong, works perfectly now!! Many thanks again Steve

I having some trouble trying to use an expression in my query, I have 3 indivisual exoressions in 3 fields I which work perfectly, however I want only 1 field produced so I tried placing 1 after the other as below: Sector: IIf([SpacePos]=3,Left([PostalCode],[SpacePos]) &...

Function Problems I did copy the function into a new module and placed first private then public in front but till no joy! Also I had basic functions working in my queries i.e. Left , Len, Repace on my work system, brought my DB home to work on over the weekend (sad!!) but now I,m getting the...

Thanks for the reply: When I try to run this function UK_Sector([NewPostalCode]) in my query all I get is "undefined function 'UK_Sector' in expression" where am I going wrong ? my field in the query is : Sector: UK_Sector([NewPostalCode])

Ok thanks for the help I have just another problem: I have now got my Post Code makeup correct but I now need to produce a sector from them. The postcodes can be in the following format: Post Code The Sector for each of these A9 9AA ----- A99 A99 9AA...