Search results

Hello, I have a form, with 3 tabs. I would like the subform contained on tab 3 to be automatically updated when a user enters that tab (screen.) How can I do this automatically? for example, I can put a refresh button on that subform, and it does indeed work. But how can I refresh the subform...

Hello, I am having some trouble with subform, listbox, add button and field for storing! Basically, what I would like to do is: the user makes a selection from a list box, and this value should be passed to a field for the data to be stored. At first I just used the wizard, but I found that...

Hello, I am trying to calculate the number of days within a certain period on a report. However, the number of days must not count Saturdays or Sundays. I can calulate the number of days using: [EndDate]-[StartDate]. But how can I take Saturdays and Sundays out of this calucation? How might...

Got it! Hello, Ah! The penny dropped. I realised that I must copy the code to the buttons on my form. Then it worked fine. Thanks for the help. Much appreciated. dj_t

Code help Thank you for your help. Im not sure where to insert the Start and End date field names. cmdFrom has: Private Sub cmdFrom_Click() Me.txtFrom = Nz(Me.txtFrom, Date) Call ShowCalendar(Me.txtFrom) End Sub and cmdTo has: Private Sub cmdTo_Click() Me.txtTo =...

Connect the date Hello, I'm not too good with VB. In this case, how do I connect the date(s) selected with my start and end date fields? dj_T

Hello, I would like to use the calendar (v9) to let users input a start date and an end date. I created the startdate field and the enddate field to the store the date information. What I would like to happen is that the user clicks on a button, and a calendar form opens up. Then the user...

Hello, I am trying to work this one out for a while now. I have a few simple tables. Basically this is my thinking: Each student has a student record, with name and other details etc.. tblStudentDetails Each student can attend many courses, so I created another (one-to-many relationship)...

count (*)? Hello Thanks for your reply. But I dont know what you mean :( sorry! anyhelp? dj_T

Hello, This is probably very simple :) but I'd appreciate some help! I have created a cross-tab query that calculates the number of fields etc... thats fine. The resulting query produces the number information I need (for example, a count of books...) But, I want to create a (another?) query...

Currently selected text box? Hello and thank you. This works fine - however, here are some queries I have: 1: The spell check button works. However, it checks not only everything on the current form - but the entire database. How can I limit the spell check to the currently selected text box...

Hello all, I have created a button, from which I would like to run a Macro when clicked. The action is the SendKeys action. However, the problem is this: I would like to create two buttons, one for the Zoom (Shift + F2) and one for the Spell Checker (F7). However, the Keystrokes property...

dont know what you mean? Hello, sorry, I dont know what you mean? If I click on the dropdown menu fpr that property, there isnt anything there? Anyhelp? dj_T

Hello everyone, I have successfully created custom menus. and that works fine.... However, I would like to embed (is that the right word?) a menu in a form. Similar to a file menu or something... How do I go about this? I searched and found some info on "Common Dialogue Control", but I...

Will this resolve....? Thank you for your reply. One little question: If I use the Access Security feature, how will this help my problem of multiple users, using the same database, at the same time? Will the security allow the database to be successfully used simultaneously? Thanks again...

workgroup Thank you for you reply. I had thought that using a workgroup would only be of use for permissions? I wasnt aware that it could help me with sharing/accessing a database intended for multiple users? (other than assigning permissions.) One reason I stayed away from it was because I...

Hello all, I really appreciate your help and advice (again :) ! I have made a few small databases for my office. They are not large things - but efficient enough and doing the job well. Now, my office is part of a very large network of computers. I dont have "admin" rights, so all my...

passing the result Thanks for your reply! How can pass the calculation back to the table (and form?) dj_t

Hello, I wonder if you can help me? I am trying to do a simple time calculation, where I can calulate the duration of a call. I can do this in the form (using =[EndTime]-[StartTime]) and the correct duration is displayed. However, this information is not passed to the underlying table. So...

Hello all, I have a little problem! I have inserted a combo box into my main form. This combo box looks to a table as its source. (By the way, the source is an excel file.) The source table contains 3 columns: Surname Firstname Grade Now, the problem is I would like all 3 fields to be...