Search results

  1. M

    Help with input mask

    You might want to adjust the picture size and/or text size to fit the image; ideally, the mask will be something like 00000000000 but remember you can use some placeholders such as - to space out the digits as needed.
  2. M

    Google Docs Competition

    I would guess the type of software you need would require a dedicated work involving a deep knowledge of web design, html, css, xml, databases, and probably even more areas. It's no wonder you refer to google when it comes to such brilliant web technologies.
  3. M

    Question programmed back-ups

    I took a look at your samples just for the sake of it, and the programming involved is way beyond my capabilities (for now ;) ). On the other hand the software you suggested works like a charm and is perfect for my needs.
  4. M

    System to store monthly sales reports

    I would point you to the "tables" section of the forum, as I get the idea this thread belongs there. On topic: your idea is flawed because you'd find yourself adding a column each month when you'll need to add new data for the sales (you might do it, but it's a pain in the neck and you're...
  5. M

    Record Cloning - Form Coding

    I'm assuming you might use something along the line of: private sub cmdEnterInfo_click() dim intloop as integer if IsNull(me.[numberofitems]) Then msgbox "Please insert number of items first!", 0, "Notification" else 'DoCmd.SetWarnings False for intloop = 1 to Me.[NumberofItems]...
  6. M

    Comboboxes and reports

    I'm just starting out with reports, and seeing I could use the standard controls as with the forms I thought I could spare the user the step of the form and give them a little more "dynamic" of a report; it's actually due to my lack of experience with them, I guess I will go with the way you...
  7. M

    Comboboxes and reports

    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...
  8. M

    Question programmed back-ups

    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...
  9. M

    Closing a form unwillingly edits first record in table

    just found the problem was caused by an instruction on another form.
  10. M

    Closing a form unwillingly edits first record in table

    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...
  11. M

    Open form with link criteria

    beautiful.
  12. M

    Open form with link criteria

    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 =...
  13. M

    Procedures and modules: efficiency question

    Thanks for all the replies. I would say it's all about the programmers' style and personal preference then.
  14. M

    Procedures and modules: efficiency question

    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.
  15. M

    Modal pop up form

    I've created the module with the global variable and everything seems to work fine, except that the execution doesn't halt when the modal pop-up is opened and the lines that expect the value of choice to be one of the possible options are executed and skipped. How do I make it wait until a...
  16. M

    Modal pop up form

    Hi bob_fitz Can you point me to somewhere I can learn how to use those? Or is it just as simple as clicking on "insert module" and typing my code there? (Even though I wouldn't know how to reference it later). I'm still a beginner, so please be patient :)
  17. M

    Modal pop up form

    I'm only just recently starting to use those, and so far I only have used the public type (which as far as I know only applies to the current module), should it be something along the line of: Option Compare Database Option Explicit Global choice As Integer in the main form? Then in the pop...
  18. M

    Modal pop up form

    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...
  19. M

    **ComboBox Values**

    If you want the button grayed out but still visible, try: Private Sub Combobox1_AfterUpdate() If Me.combobox1.value = "Employee1" Then Me.Button1.Enabled = False End If End Sub
  20. M

    DSum for last month

    Right, I typed the wrong thing but what I meant is newer :)
Back
Top Bottom