Search results

We are currently running a FE / BE splitted database abd would like to back the back end up (to a sepearate location) every 15 minuutes by using the On Timer event. Troiuble is, I believe I cant use the CopyDataBaseFile method whilst other users are in it and it would be too much hassle kicking...

Thanks Thanks scott, that worked fine Andy

I was just wondering if it was possible to run a query by a specific value first, then the remainder of the following values in ascending order. For example, the data would appear in the table as Smith Bloggs Jones Taylor What I would like to do is have all the Taylors at the top, followed...

Compact on Close is turned on, dont understand the other question!

Every now and again (for no apparant reason) a record in my table becomes corrupted (the fields all change to #Error, Error etc) Also, the relationship between that and another table breaks and when I try to go into the forms I get the "Invalid Argumnent" message I am running Win XP Pro, with...

Thanx Bit late - but thanks it worked great!

Just wondered if there was a way of converting 13/07/2005 into 13-Jul-2005, and outputting it as a string (I dont want to change the usnderlying format in the table. Had a look in search, but coulnt find anything that made sense! Cheers Andy

Thanks guys - it's cracked now - just one prob - "Flat 23" is required in the House number field!!!

Sorry mate, Im a complete novice at this. Here's my code would u be kind enough to help me sort it? If (the second character is a number) of Me.Text1454 Then Me.Text80 = "House Number" ElseIf (the second character is a letter) of Me.Text1454 Then Me.Text80 = "House Name" End If (You know...

Dont know mate! Never used that function before!

I have a field that collects data about someone's house name or number. It is set to text but will obviously store numbers as well. What I need to do is to be able to determine whether the inputted value is either a HOUSE NO or a HOUSE NAME For example If input = "The Gables" Then "HOUSE...

Thanks again!! Worked a treat too!!!

Sometimes, when running my db in a network one of the client machines will generate an error message when a print is attempted - "The Expression ON Click you have entered may have caused the following error. The event may have resulted in a macro...etc etc..." Just wondered if anyone knew what...

Thanks Thanks mate - works a treat

Thanks Works great, thanks mate

I have little problem that I am struggling to find an answer to. When I output a piece of data from my text box, it must be either 10 or 11 characters long when it goes into the receiving data base. I just wonedered if anyone knew of a way of validating the text box to ensure that it met this...

I am trying to manipulate a tab on a subform. If I place a command button on th the actual subform itself it works by using the following code Me.Previous_Address.Visible = True However, I need to perform the same function from another form but am having no joy! I have made other things...

Read it - still confused!!! Had a look, he sent me some other code that works great - this sends a text message via a web site Me.Refresh If MsgBox("Are you sure?", vbQuestion + vbYesNo, "Deal Trak") = vbYes Then Dim xmlstring As String Username = Forms!frmIntro.SMSUsername Password =...

Whilst on holiday last week I have been reading about the wonders of xml! Following this, one of my clients has forwarded a piece of code that he says is "dead easy" to use!!! erm. Maybe easy for some, but total gobbeldy gook to a layperson like me. What I would really love to do is understand...

Thanks, Did that - I think I've almost cracked it but have just one syntax error rsAcceptanceCriteria.Find"DealCode" = Me.DealCode isnt working but If I change this to rsAcceptanceCriteria.Find"DealCode" = 385 it works Am I doing something wrong?