Search results

  1. M

    VBA error with incomplete textbox

    Hello, I have a form with 3 textboxes (itemCode , txt1, txt2) and 1 button (simplifying for this example). The textbox itemCode has an input mask. User must: 1) manually enter itemCode , 2) click the button and vba script fills txt1 and sets focus to txt2. Private Sub button1_Click()...
  2. M

    Many Forms vs. one tabbed form.

    Hello everybody. I almost never use Tab Control on a form, as I always thought it was not worth the "trouble", but today someone said that Access does not like having too many forms. So basically it made me think: Is it better to use for instance 10 separate forms or 1 form with 10 tabs. Or...
  3. M

    Problem with dynamic image in MS Access report

    Hello, I have a report for printing labels on a grid of let's say 3 by 6 on A4 paper. These are peel-off labels, which can be printed either full sheet or just 1, depending on needs. The report's Record Source is a query, which contains always 18 records (to cover 3x6 grid), and 3 columns...
  4. M

    Backend choice

    Hello, Probably asked many times, but I guess I could not choose correct keywords in Google to get answer. So question is simple, I am torn between using either MySQL (or MariaDB) or POSTGRES as a backend for Access. Is there preferred choice and why? Better ODBC driver for either of them? Any...
  5. M

    Problem with Excel file after Importing to Access

    Hello I am experiencing a problem, which I could not resolve with Google. In my application I am importing Excel into Access table and also extracting data from one cell from the same file with following code: Dim fd As Object Dim File_Name As String Set fd =...
  6. M

    Problem with function argument

    Hello I'm having a problem with argument in custom function My table is like this: myValues 123.5 32.7 65.8 11.1 What I want to achieve is to multiply each value with the average of all values, so that at the end I get (avg(myValues) = 233.1): myValues2 7196.963 1905.593...
  7. M

    Get label name into procedure.

    Hello I have a form with about 100 labels and would like something to happen when I mouseover. So I have a following code: Private Sub Label1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Label1.BackColor = vbBlue End Sub Private Sub Label2_MouseMove(Button As...
  8. M

    Automatically re-linking tables (VBA)

    Hello This is not a question on how to, but more about your expert opinion. As you all know tables are linked using absolute path and if you change back/front-end location one needs to re-link the table manually. I have been searching around on how to do it automatically when both files are in...
  9. M

    Control Height change direction

    Hello I am trying to make something like custom bar chart on a form using rectangles. I made 4 rectangles (BarBZ, BarBA, BarKI and BarMA) and have the following code: Dim PctBZ As Double Dim PctBA As Double Dim PctKI As Double Dim PctMA As Double PctBZ = Me.BZ / (Me.BZ + Me.BA + Me.KI +...
  10. M

    IIF Expression in criteria

    Dear All I have a feeling there must be extremely simple solution, but I spent whole day without success. I have a form with combo box [Combo18] with the following options: All V01 V02 V03 After one of the options is selected I want to run query, where criteria is based on the selected value...
  11. M

    "Transpose" in the form

    Hello Usually I "Google" the problems, but I could not find key words for my question. I was told that if I have data in this shape: Number ¦ Test1 ¦ Test2 ¦ Test3 ------------------------------------ 000001 ¦ Pos ¦ Neg ¦ Pos 000002 ¦ Pos ¦ Pos ¦ Neg It is always better to make table in...
  12. M

    Expression stopped working

    Hello Some months ago I wrote an expression and included it into the Default Value of a form text box. It was working perfectly until one day and since then I am breaking my head, but cannot find the reason. Here is the info: It is a simple form/subform for the simple related (two tables)...
  13. M

    Join all records

    Dear experts Say I have two following tables: Table1: ID | Item1 1 | Table 2 | Chair 3 | Shelf Table2: ID | Item2 2 | Book 3 | Paper 4...
  14. M

    Autosearch

    Hello guys I am very new to Access, but not new to databases (I have been using other epidemiological software). I would like to know if it is possible to do the following: the database is about patients, who have there unique numbers (identifier). I want in the form when doctor enters the...
Top Bottom