Search results

I am designing a DB for a go-Karting company One request is that every 5 times a customer pays for a go they get a free go. they do not want to free go to be counted. So to alert them of this I want a txt box on the form that counts the records, (done this) every 5 records a msg box pops up...

I have a txt box on a form with the following code =Date(), This use to work, But I have recently re-built my PC and now I get the following error #Name? is this to do with references? Cheers

Say you have a register system and you want to link a photo of the student to there record, what is the best way to link the photo to the record? Cheers

in a qry how do you say, only show records if a certain text field has got some text in it, i.e it is not blank

can you do the following I have strmessage = " Student Number is " & me.StudentNo Can I make the text in the quote marks " Student Number " BOLD

I am using the following code to send emails Dim strEmail As String Dim rst As Recordset Dim x As Integer Set rst = Me.RecordsetClone rst.MoveFirst Do 'Place all the email address into the TO: field strEmail = Trim(strEmail & rst!Email & ";") rst.MoveNext Loop Until rst.EOF 'Remove final...

I want to click a button on a form and it opens my email program and inserts all the email address (email address field ) into the TO: field, or if it is possiabe to insert them into the BCC so the recipent can not see the other email address. Stuck on this one so any help would be great thanks

I use the following code in the on_Click event of a button Private Sub cmdsave_Click() If IsNull(Me.BillRefNumber) = True Then MsgBox "Please Enter a customer number" Me.BillRefNumber.SetFocus Else If IsNull(Me.AccomID) = True Then MsgBox "Please select customer accommodation type"...

Hi, Is there a simple command like the one below you can use for reports if there are no records found if me.recordsetclone.recordcount = 0 then msgbox "no records Found

I want to open a form based on two dates. I have a dlg box where I enter 1) start date 2) end date When I press enter I want a report to come up that shows records between the dates I enter How do I do this? Thanks

I have used this code before to count records on a form and it worked but now is does not any ideas? Dim myrecords As Recordset Set myrecords = Form.RecordsetClone Me.txttot = myrecords.RecordCount is there another way to count the no. of records on a form thanks

on form A I have a button (Edit) that when pressed opens up formB. I want the edit button to open the other form filtered I have been using the following in the on click event of the button: ________________________________________ Dim strfilter as string strfilter = "CustomerNumber =...

If you open th DB and then open frmMain press the search button to filter based on name and post code. there are a few bugs with my system 1) if you enter a record that does not exist it throws up a blank screen 2) when you apply the filter and and it brings the record up, if you press the...

I am filtering a form. if the user searches for a name that is not in the database the main form returns blank. How do I show a message box to say the no records were found if there were none. Also I am using this code to search records via a customer name. FilterString = "" If Chkname Then...

I want to be able to filter a form based on two selections 1) Name 2) Postcode so...... form 1 show all customers. I then press the filter button on the form, which brings up a dlgbox and I want to be able to select which method to filter by either name or postcode or both when I have made the...

Its stupid really but I always struggle to link the data together, would some one please show me how to link the following tables together Table 1 Customer Number Customer Name House Number House Name Address1 Address2 Address3 Postcode Contact Number Mobile Number Table 2 Accommodation ID...

hi, I could do with some help to link tables, can't seem to get it right. Table MAIN ROUTER Router No Router Address Site Contact Site Tele Table SITES Site_IP_address Site_Name Site_Contact Site_Address Table NETWORK Network_Number Network_Name It should work like this, Table MAIN...

We have a database that was designed for us and the data came form outlook. Not all the data was copied over so we have an incomplete DB . Is there any code that can check the origional copy of the data against the new one , see what is missing and copy it over Thanks for any help

I have a few questions from an exam. I sort of know the answers be would benefit some other views. 1) Advantages and Disadvantages of the client server approach 2)Dicuss factors that influence speed of a DB over a local area network, What stratagies could u employ ti maximise the...

I have to creat several versions of a menu bar, they all have the same basic functions which some added extras, it is possible to copy a toolbar once you have created it and just add bits rather than creating a new one each time