Recent content by src23

Hi everyone ! I want to create using Flash an advanced financial calculator which I previously developed in Excel and VBA. The final purpose is to obtain a standalone .exe to work on any computer, no need for MSOffice to be installed. It must have a professional interface, very nice looking and...

Hi flugh ! In Access VBA, True=-1, and when you have a checkbox checked, it hat the value True (-1); if the checkbox is unchecked, it is false (0 - zero). The same is with Yes/No fields. If you want to store 1 in a field for a checked chkbox, you should use VBA. The easiest way is to use...

Thank you ceco for your answers; In this weekend I'll start playng with the stored procedures, and try to open an ADO connection to a postgresql database. I'll be back on monday with some questions.... BTW, what o.s. do you recommend for the server machine ? Should I risk with a PostgreSQL...

You mean that if I keep that ADO Connection open, and I only change the open parameters to connect to a PGSQL database, it will work with the insert/update queries the same as with an AccessDB ? I don't know the differences between AccessSQL and pg SQL, but I think the insert/update clauses...

Hello everybody, I am new to Postgresql. I'm currently using a multiuser MsAccess database, and I want to migrate to PG because of the errors that I have to deal with, when more than 20-25 users simultaneoulsy access that database. Details about Access database (so that you know what I want...

Hi, Thank you dilettante for your replies, I read them and I found useful information there. I apologise I didn't answer sooner, I've been away from the office. For a few days I will be away from the internet, but I'll develop my database and as soon as I return (in 4-5 days) I will tell you...

Yes, there are 8 tables for menus. More details: it's a loan management app. Tbl1: RequestType (5 types of requests) Tbl2: RequestStatus (request will pass through 8 status from analysis to approval) Tbl3: UserGroup (there are 5 groups of users) Tbl4-8: For each request status, each user group...

Hi everyone here, I have a database application and I'm trying to optimize it, but I'm not sure if I'm doing it right. This database will be accessed my more than 20 users simultaneously. Initially I tried to use linked tables - I split the database, the BackEnd was on a remote comp and the...

Try with CurrentProject.Path

Hi.. I'm not sure that I could help you solve your problem though I'll be glad to try, but - if you're interested - I'd like to 'trade' with you another strange database of mine - you give me a 'mostra' , and I'll give you mine. My database 'gives birth' to some nasty query-creatures, named...

Hi. Thanks for the tips. I've been considering your advice regarding Categ1, Categ2.... and you're right. Usually, when I have to store different categories of things, I store them in a single table, like you said. But now the situation is a little different. First of all - you mentioned...

Hi. Try this: I defined two functions which I use in all my apps to get a new numeric ID in a table: 1 - GetNewID - which gives me two options: (a) gets the maximum ID value + 1 from a table OR (b) gets THE FIRST FREE ID value from a table (useful in this case...

First of all, I want to thank you for answering me, and I apologise I couldn't answer sooner. About your answer: yes, you are right, and your example DOES make sense and was meaningful and helpful to me. About the tables: FIRST - one more thing about the intermediary table that you wrote...

I want to develop an Access database (which is supposed to hold about 10.000-20.000 records); right now I'm designing the tables and I'm facing a problem which gives me two options. First, the database description: It will contain one 'wide' table - tblRequests - 48 fields, from which eight of...

Hi ! I'm trying to import an excel spreadsheet into an access table, but I want to import only columns B, C, E to H , M, O and R. I tried to import all the sheet at once into a temporary table, then run a sql and select into my table only the columns that i'm interested - it's working OK...