Search results

Okay Im officially lost ! :( ........ I cant work it out

That doesnt work because if the counter is 0 then its still true. I tried: qrycounter < 0 and that produces false no matter whether is 0, 1, 2,3 etc ect

Hi, I have the following code on my form which works as desired: Private Sub Form_Open(Cancel As Integer) qrycounter = 0 Counter_txt = qrycounter qrycounter = DCount("[Logid]", "tbllog", "[tbllog].[sitesid] = [forms]![frmsites]![sitesid]") Counter_txt = qrycounter End Sub...

I have been trying to find a solution to export a query automatically from a command button to an Excel spreadsheet. It doesnt have to be fancy just as long as I can name the workbook a name i want. Any ideas?

Hi Guys, DCrake created a great Login process form for access. I have been trying to work out a couple of things though. The passwords stored in the table are encrypted and I wondered how I would encrypt/decrypt them. A form solution would be perfect, but a general point in the right...

Well I have had a good read on Normalisation and seem to completely understand what I have been doing wrong. I am going to rebuild my database from the ground up. With these rules: Naming convention for tables, queries, forms, reports and modules. No table level lookups (lets leave that to...

Ok guys I get it now. Are you able to give me a detailed example of what I should be using instead of lookup fields?

Yes you are right. In the table it is displayed like so: Field name: qstatus Date Type: Number In the tabs below in design view: Lookup =: Display Control: Combo Box Row Source Type: Table/Query Row Source: SELECT [tblstatus].[statusid], [tblstatus].[status] FROM [tblstatus]...

Hi, Its a number data type as the values are selected from a combo box / Table Query. Does that help

Hi all, I put the following query together and it keeps returning: "Type mismatch in criteria expression" Here is the SQL: SELECT tbllog.*, tbllog.qstatus FROM tbllog WHERE (((tbllog.qstatus)="Closed"));

Bob it all works now. I had another look at your suggestions made a few tweaks and works perfect. Many thanks I have learnt a lot from that.

Have to say you seem to know your stuff. Probably a good idea to explain the logic of the calculation as that is producing -26million. Result field = std_av_base "divided" by the number of days in field: no_days "times" 365 The other thing, the b_end_date - b_start_date is not calculating...

Hi Bob, I take note of what you state about the fact you cannot put in a calculation the calculation of another field and have to use the entire code. I am having trouble putting these two together to make one entire calculation: =Sum(IIf(Nz([no_days],0) = 0, Null...

I learnt a lot from that thread!!!

I tried that but didnt seem to work. I do have two other calculations working on the form so I have pasted everything below. Is this the best way to do it or should I use a query? =Sum(Nz([std_cost_av_base])/Nz([no_days])*365)...

Hi Bob, Not sure what is supposed to be happening with that. My fault though because there are two other calculations on the form. I have pasted all below for you to look at: =Sum(Nz([I_saving])+Nz([ac_saving])+(Nz([std_cost_av_base])/Nz([no_days])*365)) =Sum(IIf(Nz([no_days],0) = 0, Null...

Regedit solution works perfect

Ok Bob I will give that a go and let you know. Many Thanks

Bob Thanks for that. It worked perfectly. Have a slightly different issue on the same form. I have =Sum(Nz([std_cost_av_base])/Nz([no_days])*365) as the control for one of the fields but it has stopped calculating and just says #Error? Any ideas?

Hi, I a form with calculated fields in it. I believe I can do this by putting =Sum(Nz([field])+Nz([field2])) in the control source on the form field. So anyway. I have a requery macro in the after update box and it keeps trying to create a new record. The form doesnt like this because it...