Search results

I'm trying to understand what's going on from your example. By putting something in the control source property you are binding the combobox to the 3rd column in table1? For me the equivalent would be a field called lastname in table tblpatients. If i make that the control source it doesn't...

i've just asked you the same thing in my other thread! I'll read the article but I think i can be more concise: How do you point an unbound combobox in a form at a particular field in a table? I think its the row source property but its only offering me a list of objects, not fields.

bingo! thanks mihail. i'm now using an unbound text box. If you change the format to a date format, when you click on the box it gives you a date picker. Now i'm trying to do a second box to select a name for filtering. I inserted a combobox, but it's displaying numbers -i think they are the...

Please can someone remind me the settings for achieving the following? I have a form which contains fields from my main table and also has a subform containing a query based on a filtered list of my main table. I have a combobox on the form to select a name and pass it to the query to filter...

I did have some but I had to keep taking them off to make changes and that's how it is at the moment. There should be relationships between the tblappointment table and tblpatient, tbltherapist and tbltimes. The database records therapist's appointments, allowing them to see existing...

here you go. Forgive the untidiness, I'm using it to learn access and i'm leaving a bit of a trail...

I am creating a form for data entry into my main table. It shows all the fields including a name, date, id number etc. I am trying to put a subform on the form containing a query. The query has two filter parameters fed from two unbound boxes on the main form (date and name). Their purpose is...

I should also say i'm using a2007 but my end users will be on a2010

That works great - thanks! I need to pass the date as a parameter too. I can't see a control for that in query design view. Is it possible to have a calendar-like control?

I want to build a form that allows a user to book an appointment. I want them to be able to see a choice of their own or other people's appointments for the day so they can choose a time. I'm told i can build a query to show the appointments and put that in a subform on the form. My question...

Wow, what a pita. I'm sure they have a good reason for it but it doesn't make it very user-friendly! Hmmn... 11:45 to 12:15 is returning 2880, *24*60 is 4147200. I'm not sure I understood you correctly?

I was told that a duration didn't format correctly as time. When I did use time every result displayed as 00:00 (the value and the format). appendid and appstartid are number data in my original table and they refer to a table of appointment times.

Thanks for this. I changed to general number and it seems i need to divide the result by 96 to get the number of minutes. I have no idea why it's 96 -thats not a multiple of 60 etc?

i;ve worked out where the figure 15 is coming from. The table i;ve set up to list appointment times is in 15 min intervals and access is returning the number of 15 min blocks -so i'm just x by 15 to get want i need. still not sure why datediff isn't working though.

i've tried the datediff function: dur: DateDiff("n",[appstartid],[appendid]) (i don't know why it adds in the square brackets) 11:45 to 12:15 is returning 2880 in general number format and 00:00 in short time.

I've tried to provide a duration for an appointment on a form by subtracting a start time from an end time e.g. appstartid = 13:15 appendid = 16:30 appduration: tblAppointment.[appendid]-[appstartid] returns either 00:00 if formatted as time and 13 if formatted as a general number. Both...

http://access.mvps.org/access/lookupfields.htm there's a heap of reasons here. I only understand a couple of them at the moment!

OK - I'm part of the way there. It seems I've used lookups in a table which is taboo (table-oo?) and so I've changed them to use id fields and after some adjustments eveything seems to behaving itself and I now have the short time format (thanks for that tip - needed hh:mm rather than hh:mm:ss...

excellent - thanks! I've looked into it a bit more and it seems using lookup fields in tables is bad style - maybe this is one reason why?

I've backed myself into a corner and I'm having trouble getting out. In my table I have two fields for time (a start time and end time). I used the time/date data type but when I came to use the lookup wizard to add a lookup of a list of time slots I got the error 'the lookup wizard doesn't...