Search results

I'm not sure how to go about it, so I thought to ask for help. I have a form that inherits a IDClient. The form has a subform with a recordsource made of two tables joint together (Articles left join Sales). Every client can have some 'sales %', always not more than one for each article. Now...

Hi, I absolutely need your help. I put down a function. The function seems to work as intended. What I can't do is to extend the function to entire column. Help! [Public Function ADI() As Variant Dim cv, N, Tot As Integer Dim sourcerange, fillrange As Range Dim lastrow As Integer cv = 0 N =...

Ok, so I seem to always make stupid mistakes, and I imagine this not to be a different case. However posting speeds up the process of finding the misspell. So, at the cost of annoying you, I'll risk my hide. Hope you take pity in me and try to give me a hand :rolleyes: I need to update/edit the...

Hi, I need your advice because I don't know how to bypass the problem. I have two tables : (1) Dett_Lav , (2) MaterialiConformità. They are thus linked: (1) IDDett_Lav <---one - to- many ---> (2) Dett_LavID I'd like to preserve the referential integrity. In vba I wrote down this codethat...

Hi! Hope you're not still fed up with me :p. I'd like to appeal to your knowledge. I'm thinking about creating temporary (while db open) relationships between tables, since transfering tables is possible only if no linked relationships are present. However it's important to preserve in some...

Hello. I tried but couldn't make a sql line work. If you give me a hand, I'd be very very grateful. I'd like to put a WHERE clause where I confont the date in an unbound textbox with the date in the table. In vba I control the null case of the unbound textbox, but I'm not sure how to control...

Hi, I have a Sql code that works. I need to implement this code with a filter based in a variable. When I tried to import the sql in vba, I couldn't make it run. Could you help, please? SELECT CLIENTI.IDCliente, CLIENTI.CodCliente, CLIENTI.NomeCliente, CLIENTI.RagioneSociale...

Hello, I hope this is the right place to ask for help. I'm not sure how to write the code since docmd.GoToRecord is not a line I'm overly familiar with. I have a form where, by clicking a button, I jump to another form with a searching bar through a listbox. Now, when I double click a record...

Well, I'm not sure where to start. I'm not good at introductions since I'm usually reserved. I'm new to access and vba, so everything is 'try and learn' kind of deal. Usually I'd make a lot of tentatives before asking for hepl since I like to understand how vba and access work. :) This forum was...