Search results

In this case, the value [Amountpaid] was half of the total debt and it returned that the total was paid off...:banghead: when it wasn't

Sorry I had the Spanish version :D I dont know why in Spanish is different. IIf([AmountPaid]<[Total],"No","Yes") Regarding to June7, the problem is that someone paid a part of the debt ([AmaountPaid]) and the query returns that has been paid off. I must say that [Total] is a Dsum quotation...

Hey folks! I bumped into a problem on my database. I've got a query which says either a invoice is completely paid off or not. The thing is that in my query I have a field called "Total" and another one called "AmountPaid" and I created another which turns out either the "AmountPaid" is...

Hello folks! I've bumped into a problem developing my DB. I've got a form to create quotation reports. Sometimes I'd like to show the price per unit and others not. So what I've tried was to create a toggle button to change the properties of the report to either display the price unit column...

Thank you so much!!! That was exactly what I needed it. I works now perfectly. Thank you everyone too. You're the best. ;)

Thank you for that. The thing is that the UPDATE query works but it does as long as the "numero de piezas" (Number of parts) is lower than the Stock. I don't know if you could give me a hand with an If or Case formula. Like if the Stock is lower than number of parts..... this else " my current...

Hi there. I bumped into a problem while programming. I firstly have to say that I'm not a professional programmer so I have been doing all this on the go. I have a DB for a company. I create dispatches notes to pressing a button and it also updates the stock. Sometimes, for unforeseen...

Sorry for the lack of information provided. I thought It was because I wrongly put a coma, quotes or something. And yes I found out what happened. Maybe it was because I spent 12 hours with this and I couldn't see that the spelling of the table was wrong :banghead:

Hi there. I'd like to use this to delete a record from a form. I cannot use the easy way such as "DoCmd.RunCommand acCmdDeleteRecord" so there are so many different fields from other tables that this command actually works. So I am forced to use a sql delete to do it. Dim sql As String...

Hi everyone. I have my db finished but after using it on different computers one of the Dlookup functions stopped working and I don't know why. Basically this to create a pdf along, change the status and decrease the stock. salbaran = DLookup("[AlbaranNumero]", "tblAlbaran", "[AlbaranID]= " &...

Hi Static I think the problem is that the display of the records. What i have been looking for is a way to display on the first tab all the information and on the second tab a subform linked to the first tab. Cos I could not do this. What I did was to put just the ID on the "main" form and...

Hello everyone. First of all, sorry for my ignorance. I think that my problem might be that the information is split across the main form and the tabs. I thought that it would be the right way to built my navigation form. I just have the ID on the "main" form because I have this one linked...

No solutions yet? :(

No solutions yet??? :(

Please I need help. I couldn't still find a solution... :(

Hello BJF I think the ClientID has to be in the main form as it is needed as to set the link master and child master fields from both tabs. Am I wrong? Thank you for your answer

Hello everyone. I have a navigation form in which there are 2 tabs. The main form has only the ID field whereas on the tabs the fields are linked to the ID from the main form. The problem is when I want to introduce a new record. The new records I want to introduce are on the first tab but...

Thank you Tieval for your answer Sorry for my ignorance but I dont really get it. So I have to create a bound textbox (control source: ClientID) and this bound to the textbox "ClientID" from the main form using the default value? That being so, I pops up another error when I introduce data...

Hello everyone! I bumped into another problem. This time I would like to enter a new record on a navigation form. The problem is that the ID is on the main form whereas the rest of the data is on the tabs. To make it clearer I recorded a video. https://youtu.be/HBqOf7h6dC4 I hope you can help...

Thank you very much!!! You saved me!! It worked perfectly! :D