Search results

I want to a convert a month written like , 31/01/2025 into a number example = 1 etc , is there a function that I can use at MS Access Query level I tried this below its not doing what I want: Private Function GetMonthNumber(pstrMonthName As String) As Integer Dim i As Long For i = 1 To 12...

I will do a video on I solved it for other to learn

I think there is a total misunderstanding here. When a user is creating some invoice detail line the current stock balance is automatically calculated the moment the new stock quantity is entered, what fire the calculation is the after event on quantity control. At this stage all is fine, the...

I want to be updating a control called currentstock whenever I launch a query below instead of me doing it manually to avoid mistakes. At the moment the update is put on afterevent in the subform and it fires immediately I change the quantinty but does not fire if I requery the data unless I go...

Many thanks Mike you pointed me to the right direction with a minor amendments to your code, this now work correctly INSERT INTO tblLineDetails ( InvoiceID, Quantities, SellingPrice, ProductName ) SELECT DMax("InvoiceID","tblInvoiceHeader"), tblLineDetails.Quantities...

Thank you so much you appear to understand my problem and its almost just there, check on the child tale the key being entered 1 instead of new foreign key called 2 , if this can be achieved that is all I want.

Is there a way to insert a foreign keys, that is my query nothing more

When you create an invoice and you discover that the entire invoice is wrong. Then you must reverse that invoice , create an opposite document called credit note referencing the invoice being reversed . This record will have its own primary and foreign keys in both the parent and child tables...

I have created an insert query it works exactly as required but its not inserting the foreign key in the child table , if that works then is exactly what I wanted. Insert queries Private Sub CmdDuplicate_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "Qry01" DoCmd.OpenQuery "Qry02"...

Very good understanding sir

What I want to archive is to completely reverse the transaction without changing the copy record here, for example see the picture below: I want the same record to be copy into the next new record that is it nothing else

So, are you trying to add a single or multiple new records in one go? If only one record, then you don't need a loop (Do While). I need the same record to populated in both the parent and child

Kindly see the example database for easy experiment , I want the same record to be copied to primary key number 2 to make a copy of record on primary key number 1. I do want people to be capturing manually , this way we will avoid errors, both record in parent and child table must be the same...

The record is properly retrieved and I can edit it the problem is the it doesn't come with a new primary key, I'm simply trying to create the exactly duplicate record with just a new primary key ,think of reversing the record or a credit note the only difference required here is that the record...

I have tried that but it is adding zero record up to infinite until I had to stop it by rebooting The parent table and the child table need to have the new record

Hi I have managed to get the underlaying record by filtering, from the filtered record I want to create a new record to be used as a credit note. The filter below gets the invoice detail all of it, instead of recapturing the records one by one I'm using filter below, now I want to use that...

Many thanks to you all and your contribution are highly valued. We sorted out the issue exactly like what Minty said it was the security features with the mixture of VPN and the router.

I have two computers using the same network in the same building storing the information on MYSQL (Cloud), now as long as I'm in the same building computer B can access the resources stored on computer A which is the JAVA file by using port number 8080 because the public IP address on both...

My apologies people for taking too late to reply to this issue, I have been investing why the CDO does not work well with runtime. I have finally found the truth here: (1) The CDO was created to work with full MS Access not depleted runtime period.

This sounds like the index issues here, if the tables are properly indexed and you are using wired local area network access works faster. Never use WIFi in this case. Shifting to SQL Server is like climbing mount Everest, if you really want performance forget about that SQL server its just a...