Search results

Dear all, it's been a while, but once you become acquainted with Access and databases, it stays with you and you begin to imagine applying all sorts of solutions to everyday problems thorugh its use. Therefore, I am a bit a rusty and could use some advice before diving into form design. I am...

I've spent several hours searching the internet but haven't found a proper solution yet. I have a few hundred access databases all with the same tables and structure, and want to import all the data in a 'mother' database (which i created with the same tables and structure). I am using a sub...

Dear all, I seem to be unable to get this right, and it always takes a lot of time to plan in advance, so rather than screwing it up and then hastily patching and fixing it, I would like to start off with the right foot this time. I am designing an application that lets the user see several...

Hello dear readers, I am trying to implement a bound (to an RTF memo field) txtbox on a form and I can't find a workaround for an annoying default feature of access: my "enter" key keystrokes move to next record. I managed to prevent this behavior, at least, with a key capture routine, but I...

Hello all, I've set up a routine that fills out several different .docx word documents from an access console, based on the answers of .accde questionnaires. It all works except for the part where I have an On Error GoTo statement that I prefer to keep commented so to make sure everything runs...

I needed my report to only show the records retrieved by a specific query, so I used the following code in the Report_Open event: Me.Report.RecordSource = "SELECT Clienti.CognomeContatto, Clienti.NomeContatto, " & _ "Clienti_Ricette.MeseRicetta...

I am currently about to finish working on a database project and am looking for a way to programmatically save a backup of my database backend every day or so, for instance, on an FTP server. Do you know if I can do this from Access or can you suggest a 3rd party piece of software that might do...

I have a form that is used to only add new records, and I noticed this odd behavior even though I haven't been able to reproduce it on purpose. Basically there's a button to save the new record (for which the data is entered via a few combo boxes and text boxes), and only leave visible another...

I want a form to be openable from various other forms, and have used the following code to pass the ID from the original form to the opened one: DoCmd.OpenForm "frmAggOrdini", acNormal With Forms!frmAggOrdini .DataEntry = True .cboCliente =...

I have a simple question, the answer to which might be complex though: "is it better - in terms of efficiency (overhead, computing time) - to have more procedures in one module, or to split them among different modules?" I am not considering code clarity here, but the machine perspective instead.

I would like some advice on how to build a modal pop up form in the following situation. An event (entering an order with a cost that exceeds the availability of a certain customer) will open said form that is going to have 3 radio buttons to choose from. I designed it so that the user cannot...

I need to implement a new criterion in the following DSum, it now has to only sum the values for records that have a DataDecorrenza (that's a date field) not older than last month from Now(). I.e.: today's may 24, dsum must only consider records dated april 1st and older. As it turns June, only...

Main form's record source: SELECT Clienti_Ricette.*, Pagamenti.* FROM Clienti_Ricette, Pagamenti The subform is a datasheet meant to view and possibly enter new records in the table Pagamenti. subform's record source (from the afterupdate of a cbo in the main form): mysql = "SELECT Pagamenti.*...

After following all the mandatory steps in my "before posting steplist" (research, experiment, further research, frustration, further experiment, utter failure), I decided I'd ask you guys. The task at hand is the following: table1 AS t1 has the presWorth (currency) field; table2 AS t2 has the...

I decided there's a flaw in my table design after several days of inability in solving a problem with the "residue" field in one of my tables. I have the following situation: Some customers have prescriptions which come - for those eligible -, each month, in various worths. They give these...

I have a table with checks of different worths and customers can place orders and use part of said checks to pay over time. ex. tblChecks: check1-worth 50€ check2-worth 20€ tblPayments: order1-worth 25€ I want that 25€ be subtracted first from check2 leaving it at 0, and the remaining 5 from...

Do you see why I get a "Syntax error" when I try to run this SQL instruction? UPDATE Clienti_Ricette SET Residuo = Residuo - 46,48 WHERE Residuo >= 46,48 AND IDCliente = 472 The WHERE part gets highlighted.

I have a table that holds the information for the "Ricette" (literally prescriptions, practically checks provided to some of our customers by the public health system). I think an example will come in handy to explain the situation. A customer places an order for a total worth of 95€. She has...

Consider the following: Clienti_Ricette (Customer_Prescriptions) holds the information for the vouchers of different worths that customers may or may not have/use. Therefore I'd like to do so that Ordini (orders) be related with Pagamenti_Ricette (Payments_Prescriptions) only when a given...

I have a text field in a table that has an input mask like the following [MON]-[YEAR] example: APR-2011 Can two combo boxes be used to input the first and the latter part like in the following, let's say, "drawing"? [___v]-[____v] JAN 2011 FEB 2012 MAR 2013 and so on..