Search results

  1. B

    Calculated fields in continuous forms

    i have a continues form that lists all my active items and I'd like to use it to quickly check if they have all the data inserted, ie entries in each separate table. it looks like this I perform a simple check on form load chk = DCount("[phID]", "preh", "[phbID] = " & Me.tID) where me.tid is...
  2. B

    Counting and displaying all different values

    As part of the report I'd like to have a table that would list all different values in column in column A and the number of times they appear in the table in column B. I have a bit of a hard time how to populate the table the easiest way. I have all the values in a separate source table, so...
  3. B

    Fancy looking age distribution

    Anyne knows how to make a graph for age distribution? Something like this https://support.google.com/youtube/answer/1715072?hl=en ihav e a query that has all the ppl and their ages in it
  4. B

    change date by month

    I use textboxes to limit the time periods for report the defaults are set to first and last day of previous month I'd like to add a button that would set you a month back/forward, but I'm stuck on how to change values to correspond to first/last day ofprevious month this is my onload code
  5. B

    encoding of textbox or variables

    I'm using a textbox to write a msg. I write in slovenian language, so there are letters that are in that encoding. Textbox, and more or less everywhere in access, displayes and stores values as I type them. But when i use the txtbox as a source for mail textbody it's send with strange signs in...
  6. B

    send object with gmail

    i'm sending mail using local server, so no outlook. i know how to attach a file with a fixed name. i'd like to add the ability to attach whatever file from the comp - pictures,pdf,office files, where you'd chose from comp through fileexplorer whatever you want. Is that possible?
  7. B

    Pictures on buttons - size

    I made nice little icons for my buttons, that look oh so nice but when i transfered the app from laptop to server and run it on desktop comp icons get resized. Guess it has to do with desktop resolution How can i avoid this? I tried with adding commands to playin pictures, but there are...
  8. B

    save additional data from report to xls

    i have a form where user can chose his own criteria for the report, like time period, ppl involved and other parameters. i open report filtered with these conditions. I also create a nice help text (as public variable) bout what where the search criteria and put it in the header/footer. Then i...
  9. B

    select rowsource problem

    i have unbound combobox, to chose from a list of ppl SELECT [name] & " " & [surname] AS Expr1, tblPpl.user FROM tblPpl ORDER BY tblPpl.UserType, tblPpl.user.Surname; i want to add a button, that would change the default order from name+surname to surname + name sthg like...
  10. B

    select all fields that contain textbox value

    I'd like user to input what he's looking for in a textbox and then to filter all the records that contain that word. values could be like rome, paris, belgrade when user inputs rome, all fields containing rome should appear tblTest like '%rome%' should this work tblTest like '" & Me.txtTest...
  11. B

    Selecting and storing one or more choices

    At data entry i'd like to assign some denominators for quick searching later. let's say these are interests like sports, games, music.... there could be one or more categories for each person, and in the end there could be a lot of categories, certainly 20+, but the idea is that i could add more...
  12. B

    update table with unbound checkbox

    very basic question how do you update table with unbound checkbox? I'd like to add basic yes/no, true/false on update. currently I'm using a workaround like this If Me.chkInkt = True Then status = "true" Else status = "false" End If which is ok if there's one of...
  13. B

    refresh from subform

    i have some general info - name,surname,birth... in the form header if you want to change that, you have to press a button, that takes you to a popup form where you edit. i have problems applying edits on exit from the pop up form. i tried forms!MainForm!requery, but nothing changes nothing...
  14. B

    check if system time is correct

    every day, the first user that opens the database, resets some values to start value. But sometimes, it happens during the day. Could it be beacuse the time is wrong on some computer? Is there a way to check if local time is right? or just use some internet based time (which could be a problem...
  15. B

    AutoShutDown

    I use a timer based event that shuts down the frontends after some idle time. i have two questions. 1. how to disable the timer as it causes some weird bahaviours while editing the code? is shuting down the hidden form enough? 2. is there a way to add regular maintenance intervals, ie every...
  16. B

    Not sorting the rowsource

    I have some dropdown lists to select on the form. You can add new values (not in list event) and they add to coloumns in a table. there are blanks as each entry in a different coloumn adds new row. it works more or less ok. But i'd like to manually add the values, so that those that occur more...
  17. B

    Open excel, go to sheet

    I'm currently thinking to put some help files into excel, and would like to call them from on click event of the button. Don't want to keep them in access as the main file gets large and takes to long to load on some computers/when lan is crowded. I use this to open excel Dim xlApp As Object...
  18. B

    send data from one database to another

    i have two databases, both have mysql backened and access frontend. In first database, I'd like to access the second database, check if that person has an entry in the second database and then fetch that data into the first database. To make it easier, data come from different tables (though I'd...
  19. B

    problems inserting numbers into mysql backend

    I'm trying to change my backends to mysql. I have the following routine enter new person data, get the ID in main table, write that as foreign key in table 2, which should be straightforward. But I can't get this to work DoCmd.RunSQL "insert into table (tOrigo, tDel,t-bID) values ('" & Me.tTum...
  20. B

    Problems with schedule

    I'm making a schedule maker for operations. sometimes the same person has two different procedures at the same time, with same or different team. Currently we only have one entry for that with both procedures, but for statistical purposes I'd like to create a new entry for each procedure, ie if...
Top Bottom