Search results

How can I find numbers in a string

Try this link to the MS knowledge base http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q170700.

I have used the statement: Forms![frmUpdates]![txtsofar] = Forms![frmUpdates]![txtsofar] + 1 in a loop in a module. I was expecting the form to visual update as the loop is processed. For some reason the form is only updated when the loop ends Is there another statement I need to use to...

The exact error that appears is function or interface marked as restricted or the function uses an automation type not supported by visual basic.

Have an access database with a front and back end. Front end holds forms etc and sits on each local pc and the backend sits on a network server. Most of the users are working ok bar 2 they recieve compile errors. When the database starts it runs an autoexec macro that basically checks version...

That explains it. Cheers

Designed a query SQL below: SELECT tblNewOrders.[Date taken], Sum(tblNewOrders.Upsell) AS [Total Upsell], Sum(tblNewOrders.Price) AS [Total Sales], Sum([tblNewOrders]![BI]=True) AS [BI Schs], Sum([tblNewOrders]![CS]=True) AS [CS Schs], Sum(DLookUp(" [tblNewOrders]![Upsell] ","tblNewOrders","...

I'll give it a try Many Thanks

Is there anything I can do to get rid of an error "record locked couldn't update". I'm not in the tables at the time neither is anyone else. The database is on a network, whether that makes any difference, probably not. Do Until Authcodes.EOF...

Yes perfectly safe. I think what acces does is get bigger to accomodate tables that you create. However when you delete a table access doesn't shrink in size. You can delete all the tables and it will still stay the same size it was with the data in it.

Fixed. Many thanks

There is something listed as missing. Can't read it but it says something about common, sorry can't read the rest. It also says that on pc's that aren't having problems.

Don't think copying and renaming the form will make any difference. The database is constructed with a fron and backend the users see the fron end with the forms etc which sits on individual pc's. This then has links to the data in the backend. Some copies work some don't. The copies that...

Checked all this and everything is OK. The tick box is there in VBA and the vba332.dll exists in the same directory for everyone. If I re-install the full copy of access 97 over the top of the original everything is ok. Any more ideas!

((tblMain.[call back])=date()) and ((tblmain.userID)=Currentuser())) This is a copy of the statement that is displayed in the error box with the function not avalable message. Its been working fine until today and no changes have been made to the database.

its a dcount function thats causing the error and also some vba behind a button. Any idea what reference is needed?

I keep getting an error function not avaliable when trying to run a certain statement in Access. Any ideas?

No I have a query that I want the text box to get its data from.

How can I use the data from a query and put the result in a text box. I've tried the following but it doesn't work Me![Order Total] = [qryCalculateInvoiceCost]![SumOfPrice]

I'm trying specifically to do the following Myrecordset.FindFirst "[User ID] =" & CurrentUser() it blows up with an error. Any ideas?