Search results

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...

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...

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]= " &...

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...

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...

Hello everyone. The problem is when I click a record from a "Search form" this one links the original record form using the code DoCmd.OpenForm "Piezas", acNormal, , "PiezaID=" & Me.PiezaID Once this form is opened and I try to navigate through the rest of the records using a next and previous...

Hello Everyone. I have a problem with my database. I am trying to delete records from my subform but I cant find the solution for such a simple operation. I have been trying with code like DoCmd.RunCommand acCmdDeleteRecord but its been fruitlessly. To explain the problem in much easier...

Hello everyone. I have a problem developing my query. This is to be used in a search form. The source of the query is just 1 table with 5 fields + 1 calculated. When I try to insert some criteria in the calcultated field (FormatCurrency(Dsum("Total","tblOrderDetail","[OrderID]="&[OrderID]))...

Hello there I have a search form in order to show some records according to show dates from some controls. The problem is when I choose the date from the unbounded control, this transforms the dates into American way instead of European and the outcome is wrong. For example: If I chose...

Hi there I bumped into a problem with my db. I have a form with a subform and I would like that when a press a button the properties of this subform change to Allowdeletions= False The problem is that I don't know what code I have to write to do so. Any ideas? Thank you

Guys I need your help. I bumped into a problem.... The thing is that in this form when I introduce the date ("Fecha" in Spanish) in the txtbox to filter the form, this does not do it properly. I realized that the problem is that the Format of the date is in American (eg. "12/31/2016") instead...

Hello there Maybe this thread has been solved in the past. In that case my apologies but I couldn't find anything. The problem is that I am trying to add some functions to a form and a button. Well after finishing I get the following error message: The expression On Click you entered as the...

hello there I bumped into another problem developing my database. This time after exporting some data to a pdf. file I want some command buttons to be disable. I set the me.refresh command but It does not make any difference with reference to this issue. I was wondering if there is any...

Hello everyone. "Developing" my data base I bumped into another problem. Now this time is that I am trying to set either a order is New, In process or Closed. To do so, I created a table with these 3 States and Referential Integrity with the table Orders, so number 1 is New, number 2 is In...

Hello there. I am trying to create an UPDATE query on vba but I don't how to do it. I have been watching lots of tutorial about how to do it but I am too noob. I hope you could give me a hand. I have this code so far. I hope it would help to spot what is wrong. Dim Ssql As String Dim...

Hello there Developing my database i bumped into this problem. I wanted to compare 2 values from 2 columns of a combobox. Depending on these logical operations of these 2 values, a third text box would change its value. This is the code that I have so far to make it clearer. This code...

hello everyone. Working on my database I bumped into this problem On my form I using some Dsum funtions to add some figures from the form, but when I'm going to introduce new data into the form, this fields are obviously empty and returns #ERROR and I would like to get rid of it. I have been...

Hello there! I am working on a database and I bump into a huge problem. I have 2 tables: Dispatches Notes and Invoices and both are linked together in another table "tblDispatchNotesInvoice" On the form in order to develop the invoices I choose the "dispatch notes ID" using a combobox with a...