Search results

Thanks for your reply Alisa. I've stayed away from bound forms for two reasons, speed - when running across a network using aq split database there is no network or db overload. Also, if there was a network error then the record could be lost or corrupted. I dont want the dabase to create a...

Thanks for the reply. I half expected that to come back and you may be right. It could be a wood for the trees mental scenario! The reason why I have done this is for example; when a user creates a new appointment the Db also creates a task which becomes due a day after the sceduled appointment...

Hi All, In my Db a user opens an unbound form, which on oppening retrieves the next autonumber value and remembers it in a hidden txt box. Once save is clicked then the values are saved to the database. However, i recognise that in a multi-user environment another user could also open the same...

Thanks, that really useful and seems to work fine. Now I just need to get Access to capture the results but I will see if I can figure it out.

Sure and thanks an example would be super.

Hi All, I've looked though all the associated posts on the site and googled but not as yet come up with an answer. Basically i want to ping an ip address from a command button in access (1st stage anyway) I'm using this code to open the cmd window and ping an ip address but it only opens the...

Hi All, I have set up an ODBC link in a excel worksheet and in the worksheet I want to have a dropdown control populated from one column from a Access Db. What's the nest way of doing this please? Thanks.

Autonumber may be a good startpoint but I have come across scenarios where autonumber is a bit of a pain and i think the more 'programmer control' which can be utilied then the better and greater flexibility.

Thanks Rabbie, Good information indeed. In my case have gone fo rthe DMax approach with error handling which I think should be good enough - at least for my purposes. Having a separate tbl to store id's seems to be adding an extra step. Thanks all for your posts and feedback.

Hi All, I'm posting to see what other methods for doing this there might be. In my db, which is multi-user, users enter call history details. This is via an unbound form and a INSERT INTO script. The problem lies where on the form, it looks up the next value in the table for the CallID value but...

Hi Pat, Thanks for that answer which I've been able to do something with SELECT CompanyCode, [InvDate], [Order Value] FROM QryFSI UNION ALL SELECT CompanyCode, [RecDate], [Amount Received] FROM QryFSR; This works quite nicely but I think i need to redesign my Db to have, as you say, all the...

Hey there Alan, I've tried it in a number of ways but typicallly a reference on TblInvoices.CompanyCode = forms!FrmDatabase.CompanyCode and a join TblInvoices.InvoiceNumber to TblfinanceReceipts.InvoiceNumber but whereas there are two invoices due the query returnls only one value where...

In my Db I have TblInvoices.InvoiceID (PK) Tblinvoices.InvoiceNumber Tblinvoices.InvoiceDate Etc... then also TblFinanceReceipts.ReceiptID (PK) TblFinanceReceipts.ReceiptDate TblFinanceReceipts.InvoiceNumber Etc At the moment one of my accounts has two invoices outstanding, I want to...

Hi All, In my Db I have TblInvoices & TblFinanceReceipts I want a query which brings all the transactions from each (the relationship will be based on companycode) to show in a report which I can thenuse to build a customer statement. Whats the best way to do this please?

Yes! That worked great! Here's the syntax in case anyone has a similar question: =Format(DLookUp("Nz([Sumofamount received],0)","QryFinanceSumOfReceipts","CompanyCode = forms!frmDatabase!companycode"),"Currency")

This is the syntax I've used but i keep getting an operator without an operand error and yes the companycode is a numeric field: DLookUp(Format(("Nz([Sumofamount received],0)","QryFinanceSumOfReceipts","CompanyCode = " & forms!frmDatabase!companycode & "),"Currency"))

Where am I going wrong? =DLookUp(Format(("Nz([Sumofamount received],0)","QryFinanceSumOfReceipts","CompanyCode = forms!frmDatabase!companycode"),"£#,##0.00"))

Thanks, am not sure how to write it but will investigate

Thanks, this is what I did.

I have a txt box on my form set to currency format but the DLookup string seems to verride this. Does anyone know how ui can modify the string to be in currency format? =DLookUp("Nz([Sumofamount received],0)","QryFinanceSumOfReceipts","CompanyCode = forms!frmDatabase!companycode")