Recent content by ShiftyJaffa

Hi I have a database (access 97) of training sessions which each has a date field called "Duration" (this field is in short time format HH:MM). I'm trying to and create a crosstab query which has the locations on the left and a total duration time for each month. If I try to sum the date...

Hi This may be a no brainer, sorry in advance if it is, but I've just searched this site and the net and access help with no luck so far. I've just recently upgraded to access 2007 a few days ago and want to hide the filter button (and possibly the search field) next to the navigation buttons...

You dont say what your 3 scenarios are or what type of fields your VAT status are, so I'll just give you a basic outline and you can tweak it. Create function like this in a module. Public Function MyResult (AppVAT as Boolean, ComVAT as Boolean) as String If AppVAT = True and ComVAT = True...

after your string is made up assuming strMySQL is your string, try Debug.Print strMySQL. Then bring up the debug window (CTRL G) and copy and paste the string into a new query (SQL mode) which may help find your problem.

If you bring up the properties of the query and change the top values property to 2. Don't use max, instead sort by your value (descending). Paul

You live and learn :), handy to know that. Cheers Jon

Try creating a public function like this below and calling it from your query:- Public Function StripZeros(MyData As String) Dim Count As Integer 'If blank then exit If Len(Nz(MyData)) = 0 Then StripZeros = MyData: Exit Function 'Scan it for characters and if found...

Hi Assuming that you can't get at the Price value which you use in the caption setting (which would be far easier), you could try this:- txtTotal = cmbMultiplyer * val(mid(Me.LblCost.Caption ,instr(Me.LblCost.Caption,"£")+1) This will only work if you have a £ sign in the caption, it will...

Hi In your example you are using the INSERT command which will add a new invoice to the invoice table. I'm assuming you have the invoice record already created (since you mention the invoice.treatmentname in your example) and need to transfer the cost over. You should use the UPDATE command...

Hi Your problem is that your txtStartDate field is not tied to any data in the back table and if it were I don't think your statement would work anyway. Try this If IsDate(nz(txtStartDate)) = False then txtStartDate = Dmin("TableDate","MyTable") This assumes "TableDate" is the name of the...

The error your getting is because you cannot make reference a null value. Try using NZ check it eg:- If NZ(Reports!Invoice!Item1.Value,"") = "" Then Reports!Invoice!Item1.Visible = False I suspect your other fields will not move up though once you hide this field. You may need to loop...

I'm not quite sure why you need to do this, since you can create groups within the same security file and have multiple databases access the same security file. Also having 1 security file makes sense from a management point of view if you have to maintain users and passwords. If you really...

There is nothing wrong with your code, I think the problem is with the position of your code in the frmAddZipcode form. If you try to set a control in the open event you will get an error. If you put your code in the 'On Current' event instead it should work. Private Sub Form_Current() If Not...

Hi I'm trying to configure the prtDevMode to do duplex which I have got working in the MDB, but from what I've read so far (Link ) it appears you have to open the report in design view to get at these settings which I cannot do when the database is compiled into an MDE. So microsofts work...

A possibility is that your reports rowsource refers to a control on the form which is in the process of closing or perhaps there is some other reference to a control on the closing form in the saveAndOutput_Reports subroutine. If this is the case then the report may not run because it cannot...