Search results

I have created a form for a car collection/delivery service. The form has a field for the customers address. Also in the form i have 3 items which i would like to automate ?? if possible. Firstly there is a dealer id box which when filled in i would like to autofill a box which is the dealer...

I Currently have a button which i press to log users out of my system when i wish to do any maintenance. This solution was fine when i set up the database as there were only ever 1 or 2 user in it at a time and i could advise them individually when the system required closing down. Now the...

Hi Dont know if what i am trying to do is possible and i am a complete novice at PHP and MySQL. I hope to set up a website, where customers are asked simple questions, and then the answers given are stored in a database, which i can either receive the input answers automatically or manually. I...

I would like to display a copyright message in the corner of a form, which will state Copyright Pb 2007 - "current year" so that i dont have to update the thing every 1st of January. Is this possible?

I currently have a command button on my main form, and am trying to get a list of supplimentry questions to appear when i press the command button. Currently the code i use is Private Sub cmd_nds_Click() Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "showx" Then ctl.Visible =...

I have a table called weeknumber in which i have 3 fields. Field one is weeknumber and contains a list of numbers 1 - 52, field 2 is called fromdate and contains a date to define the start of a week, field 3 is called todate and contains the date that defines the end of the week. What i am...

I currently run a database which gets the name of logged on users using the following script. Option Compare Database Private Type USER_INFO_2 usri2_name As Long usri2_password As Long ' Null, only settable usri2_password_age As Long usri2_priv As Long usri2_home_dir...

I have a form which contains an unbound check box, when selected several hidden questions appear due to the code below : Private Sub Check58_AfterUpdate() Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "showd" Then ctl.Visible = Me.Check58 End If Next...

I have created a form which when one particular box is ticked opens a subform, the subform has several tick boxes which can be populated depending on answers received. In the subform i have a command button which runs a macro that saves the record to the main table, this is where i think i am...

I currently have a form with a tick box on it, what i am trying to do is when the box is ticked, open up a list of a dozen or so supplimentry questions, some of which will require a box to be ticked and some of them will require a name to be entered. I have a seperate table available to store...

I currently run a macro which deletes a temp table using the delete object command. Users are then presented with a warning box that says "You are about to modify data etc" which I dont want them to see I just want the macro to run and make any modifications automatically. I have looked in the...

I am currently creating a daily Excel file with information for a 24 hr period. I am using the on click data txt_date1.Value = Date - 1 & " 06:00:00" txt_date2.Value = Date & " 06:00:00" which populates 2 hidden boxes, the system uses this info to pull the records from the main database. If i...

Im stuck on a project that I have received help on before. I am trying to E-Mail a daily report created by a macro in Access 2000. It needs to go out as an excel spreadsheet, but in a format that can be opened in a Blackberry. The advise i was given was to use Transferdatabase. This is where i...

I have recently created a database which exports a daily report in Excel. The problem I am having is that the reports are sent out in Excel 95 which cannot be opened by Blackberry. We used to create this report from an excel database and send it out but it went out in excel 97 format which was...