Recent content by Richard1980

Hello, thanks. Good but not the best option (or the option I am searching for). The source database has thousand of records and I don't like create a temp table. Anyway, thanks for your suggestion. Bye

Hello everyone, I am struggling with this task. I have an Excel file with a name range "DBIAS" which identifies all database data. Then I have an Access file with a form to import that database (better, that named range) into an Access table. While importing, I have to filter some records or...

Hello, I have a table where are stored market prices for different securities. This table is loaded as subform in another form and shows all price data for a given security. In the subform I insert new prices and a textbox automatically calculate the price change (on the previous day) No problem...

Thanks for your reply. It si nothing of those, but after several tries last night, I discover that it happens when using as back color transparent properties. I'll give more tries today. Bye

Hello guys, it is a strange effect I get when switching among records. In a form I have a TAB Control with some pages, when I open the form everything is ok: But, when switching continuosly among records, the font becomes strange, looking like being bold. What do you thing about? I...

Re: Error "Invalid use of Null" in a Function called from a Form_Current event Function FlightsByAircraft(Aircraft As Variant) As Long Dim rst As DAO.Recordset Dim dbs As DAO.Database Dim str As String If IsNull(Aircraft) Then FlightsByAircraft = 0 Else str = "SELECT * FROM tblFlights...

Re: Error "Invalid use of Null" in a Function called from a Form_Current event Ok... exactly what I don't want to do, as written before. Thanks.

Re: Error "Invalid use of Null" in a Function called from a Form_Current event Sure, very simple. I was working in the function code to avoid calling, completely wrong indeed. Anyway, now that error is disappeared, but the unbound textbox where the result is displayed show the previous...

Hello there, I am struggling trying to execute a function inside a Form_current event to display some stats. The Function is this: Function FlightsByAircraft(Aircraft As Long) As Long Dim rst As DAO.Recordset Dim dbs As DAO.Database Dim str As String str = "SELECT * FROM tblFlights WHERE...

The problem is exectly this. I already record GMT times, but the calculation in some situation gets crazy (i.e. UTC time for departure greather the arrival one: dep 1700z, arr 0500z) because the time field doesn't know that arrival day is the day after and the calculation is wrong. So I thought...

Hello everyone, I am struggling trying to solve this task. I have a form where I save flight data (departure & arrival time, flight time and so on). No problem about calculation of flight time between two cities if the flight does not cross the International Date Line (aka IDL) (Longitude 180°)...

Hello, sorry for resuming this very old thread, but I am searching for a login form using Blowfish encryption and this may be a great one. Unfortunately the file is not editable and the website where the "open source" file should be is not available. Any suggestion to help my search? Riccardo

Hello guys, I'd like to add a login form for the database currently in development and looking for a good (not extremely difficult or easy as well) encryption password field. I was looking at RC4 algorithm but, as you probably know, it needs: a. the message or string to be encrypted; b. a key to...

Ah ok, reading now your reply, I know that You (Chris) & Pat (probably), did not understand well my first post. When I speak about 7 kind of weights, I refer to this: I have a form where for every aircraft saved into the database the user has to load weights for different configurations. Every...

Hello guys, I have a form with 7 types of weights (7 textbox rows) showing 7 weights in kgs and the others in lbs. When the user update any weight-kgs textbox, the opposite weight-lbs textbox will be updated automatically, and viceversa. Now, I'd like a fast way to code this action without...