Search results

Hello everyone, I have a text box where I would like to restrict the entry to numbers AND to the sign "-" (minus). The options I can think of are: - either we type a character other than these, it receives an alert, - or if we have typed the numbers AND another sign than the "-", in the...

Yes, It must be helpful to first create a simple database and train on it to get used to the environment. I do that and come back if I have a specific question (to the right forum though). Thanks for the advice, I should have thought of it.

Do this mean that, if my backend is on MySql I just need to create a common attachment field?

That is what I want to achieve.

Thank you for the link. I take a look at it.

Hello everyone. I'm trying to move my backend to MySql (I posted another thread for it) and the future users asked the possibility of attaching pdf files to the records on one of the tables. The files will be approximately 2 to 3 MB. I read that it should be loaded on a server and only display...

Good morning all. Advancing as an autodidact, I'm finalizing a small Access application that must be used by a few users (15 max). At the start, I had in mind that the database was split and that the BackE was on a server and the Front on the workstations of the different users. But for certain...

Don't know what to say else than Thank You arnelgp. 🙏

Annulation will have is own number field like "Number_An". I just forgot to create it for the example.

No, the fields like "Principal", "FraisModification" and Annulation (which I didn't create in this example) will always have numbers related.

Hi, arnelgp. Thanks for the function you gave for this issue. I have managed to adapt the code to certain situations, but there is another that is beyond me. The colleagues who are going to use the application asked me to add some "number" fields as on the attached image. For example for the...

That is exactly what I'm looking for. Can you give us some explanation?

Micron I was saying that those lines were not records by themselves but referred to fields of the same record. The report is suppose to be for just one record. I will try to do with yours advices and see how it goes. Thanks again.

Sorry again to the misleading. To be completely clear. These are not records, these are fields of a same table. So one record can just have principal+fraisenvoi (these 2 are ALWAYS there) and another can have principal +fraisenvoi+fraismodification+annulation. The report will be in pdf and I...

Really sorry about the misleading and we can forget about the 0. I already manage to not have them. The problem with the Can Shrink is that the labels don't follow.

(y)

That's how it looks (sorry my main language is french) So even if a query does send back just Principal and Annulation, will the report show only those two lines next to each other ? I was thinking more by VBA. And i'm not sure on how i can create such query (and i'm not so bad at creating...

Yes, it is a good idea, but if a query sends me back only the non-empty controls, will they all line up close to each other?

Thank You theDBguy ! :)

Hello, I create an order report but the ranges must not be static. This is just an example to illustrate my concern. Food names are labels and quantities are controls. I would like that for the empty quantities (or equal to 0) the line disappears, the control and its label. For controls, the...