Search results

Hi, I have a form which has a combobox where the user selects a record from another table, this is linked (forgive me if my terminology is incorrect!) I want to hide the forms fields [managercontact] and [managertelno] depending on the value of the combobox (manager) from the table details...

Thanks for the reply... No its not in vb code. Prepared to give it a go thou! Tj

The search form which provides data on tills. Query is called qry_TP_filtered Combobox to select [division] from tbl_locations Combobox to select [tillno] from tbl_locations I want users to have the following functions: Select All Tills Select Tills from a specific division Select Specific...

Re: Search Form with radio buttons for date selection I would like to have some radio buttons with options eg. Current week Last 30 days Current month Last year How would I add these to my search form, would like query date to be one of the four above options. Thanks Tj

I have a text box for the user to enter the week number, I started thinking I wanted to have some more options here, can I be abit more clever with the options when designing a form to search by date?! I want criteria like.... Specific Date Between Dates Current Week Last 30 Days Has anyone...

Hi, Has anyone used activex controls for caturing video from a webcam or sumilar. Just looking for a snapshot that I could then forward via email from access. Ive seen commercial licences for an activex control. The form Im imagining would have a window showing the live video with a snapshot...

New to this forum, in just a few days you ppl have been amazing. Thanks for everyones help, hoping to learn more over the next few months! Tj

Thanks for that. All working now, think i might try a dcount next. Trying to count the records in the query. Thanks for all your help with the week number! Tj

Really silly question. Where would i add that? In the sql view? Tj

Thanks im happy to use ms access week number. Just need help with the coding of the query Tj

I can get the current weeknumber by adding this in the query Weekno: datepart("ww",[Datechk]) This gives me what week number my field datechk is. I also have a text box on a0another form that gives me the current weekno if I could build a query that returns the records from the cuurent week...

I have already got a query which gives me the current week number. I just need to run a query on the current week number. According to ms access were in week2 today!

Hi, I need to a query on the week number, the week number is in the table. Imjust struggling with getting the current weeks data. Thanks Tj

Hide the tab?! What a great idea! Thanks

Thanks for the tip about subform names. Ive tried the code, works great. Only problem is the form I want to control is on a tabbed page within subform. does that make any difference?

Thats great.... all sorted thanks for the suggestion TJ

Thanks for the reply... I knew about the DateAdd Function I just dont know how to use it. This is my efford in a query... thanks

Hi, I have a mainform called frm_Main containing the field AgeCalc I then have a a subform which has some tabs, one of those tabs contains a subform called frm_Bans. If the AgeCalc field is <17 I want to disable the subform frm_Bans. Any ideas? Im a novice with coding but coping so far...

Hi this should be simple! I want to add one year onto a date, I could do this in a query or just add it on on a textbox in the form? Field Name is IncidentDate from table tbl_incidents I know its so simple, new to this!

Hi, I have a box with age in called [agecalc]. I want to change the border of the box to red to indicate they are a Juvenile if under the age of 17. I already have some code to write the text, I just need to change the border of this text box called agebox =IIf([agecalc]<=17,"Juvenile!!")...