Search results

Hi guys... I've got a report which produces lists of appointments ordered by date (diary style). I want to group these appointments, so that they appear on the report per week with dividing lines between the weeks. I'm having trouble with the group method to keep one week, a monday to friday...

Hi Guru's... Ive got a main continuous form with a list of data subjected to two filters...I have an option which opens another form displaying only the relevant columns so it can fit everything on the screen. I want the new form to adopt the same filters as were selected in the old form. How...

Hi Access Nutters... I want my code to chech if a feild is one of a list of items.... I can set it up using 'IF's but the criteria can change over time. What would be good is if I could check the field against a table. I'm not so sure how to go about this ... has anyone done this before...Any...

Thanks bob. Any help is good help (generally). I am getting better at this stuff but I have a lot of knowledge gaps which cause problems.... Thanks for your help...Let you know how I get on... Paul

Hello guys... I can get my combo boxes to filter but what is the code to made them order the listing depending on the field criteria selected from the combo box. Having a bit of trouble getting this right. Can anyone help? Cheers Paul

Hi Guys, I'm using the following code to update a set of address fields from a table when a company is selected from a combo box... Dim dbf As Recordset, qdf As QueryDef, strSQL As String strSQL = "SELECT * FROM [Purchases] WHERE " _ & "[Company] = " & Me![Company] Set dbf =...

How's it all going guys... Getting much better at this lark but I'm trying to get data in a continuous form to repeat itself in the next entry of the form. I.e. someone is inputting data into a form using a continuous form, some fields will be the same for a set of inputs, I need those fields...

I have a master dataset which has other smaller datasets added to it. Each item in the data set needs a unique ref. I use auto number in the main data set and use a small form for people to create other datasets. The problem that I'm having is linking the two datasets so that they both have...

Hi guys..>!! I'm using code to auto update 5 address fields from a company name selected from a combo box on my form. The after update event is the one i'm using... the code is short ...Dim dbf As Recordset, qdf As QueryDef, Strsql As String Strsql = "Select * from [Company Benefits] Where " &...

Hi guys, A bit of a strange one, but I have a specific check in my application which will not let users exit unless all updates have been made satisfactorily. What's happening a lot is that users will just close the access window to exit instead of checking the database data correctly. HOW CAN...

Maestro, Had a similar problem myself once .. this is how guru talismanic saved the day... {If you don't want to use express then make sure that your default email program is outlook. You can set this through options in your web browser) ----- Put this in the event that you want to trigger the...

Hi guys, I'm trying to update a group of fields on a form based on the value I select from a combo box. I want to select the company from my combo box then I want the five form field below it to automatically fill with the five lines of it's address stored in the table. Just can't quite seem...

cjolma! Switch on the Tools Wizard when you insert the subform this will guide you through the linking process Hope this helps... Paul

Hi Guys, I'm having trouble using one form for several data sources (tables). I want to use the click of a button from a control form to nominate the data source when to form is opened - but can't seem to get it right. Do you include the table ref in the "Openform" expression to open the form...

Hi Guys, When I use continuous forms the last record in the list is always a blank new entry with my auto number field showing (Auto Number)I don't want it to keep showing me this - how do I get access to stop? Hope you can help

Hi kids! I want my form to filter by date of a field - the date come froms an updated text box. It is this value that I'm trying to use as the filter criteria, after a click on a control... I set a variable to be the date, included it in the filter criteria and now access keeps asking me what...

Chrityg - Thanks alot Hope I can recipricate in the future...

Hi Guys, (again) Thanks to Jack Cowley for helping me with the last request but I still cant quite get the command button to translate the data source to the form. I'm using this: Dim D As String Dim stDocName As String Dim stLinkCriteria As String stDocName = "Form-Unresolved-callbacks" D =...

Hi Guys, (again) Thanks to Jack Cowley for helping me with the last request but I still cant quite get the command button to translate the data source to the form. I'm using this: Dim D As String Dim stDocName As String Dim stLinkCriteria As String stDocName =...

I'm sure that you can use the same form for different tables or queries by using a command button to select the record source.... However I can't seem to get this right does anyone know how to do this - would be greatly appreciated Thanks Paul