Search results

Afternoon Folks Please can somebody help me with a problem. I have an Access form with a command button - the button runs a access macro which uses the transfer spreadsheet command to export a table into an excel workbook. All this works fine but I would like to apply some formatting to the...

Can someone help me with this problem please? I'm sure it is pretty simple but can't seem to figure it out. I have a form with a subform on it. When users enter data onto the subform and presses back - the data is saved into a table. Here is the code behind the table...

Can someone advise me how to use Captions and not Access actual fieldnames when transferring a query into Excel please? I have the following line of code which exports the query - it works fine but I need it to use captions instead of the fieldnames. /code DoCmd.TransferSpreadsheet acExport...

Hi Can someone help me please? I have a form based on a query. The query has 5 related tables in. The main table in my database is called contracts. If there are no records in the contracts table - when I open the form - it just displays blank. Can someone advise me of a work around to...

Hi Can someone help me with this please? I have inherited a access database which has a hyperlink to a excel pivot table on a form. The database has had to be moved to another network drive. All the queries still work apart from this pivot table. Once you click on the hyperlink - it...

Hi I have been searching around the forum but havent stumbled across the answer. I have a form which has a field called ContractNumber. I would like a hyperlink which would open a document with the same name as the contract number. Example: If the field has 123, I would like to open...

Hi Guys I was wondering if someone could point me in the right direction. My job has taken some interesting turns in the past few weeks and to cut a long story short - I need to learn some new skills fast. I was wondering if anyone has taken the jump from Access to ASP. Is it any easy...

Hi everyone Please can someone help me with this problem I am having. I have a form with a subform on it. On the main form are two date fields - when the user enters the two dates - the subform shows any records which fall between the two dates. One of the fields on the subform is a...

Hi I have a form with a sub-form embedded within it. On the main form, I have 2 date fields, when a user enters the dates - the subform updates and shows records applicable within those dates. One of the fields in the subform is a Currency field. What I would like to do is to show the...

Hi everyone Can someone advise me what I can do to fix this problem please? I have a query which calculates how many days between two date fields which works great. I use a module to do this and call the function in my query. The database is for Taxi Scheduling. If a user selects a...

Hi Please can someone help me with this? I need to create a huge report which spans across 4 pages. The report has many fields in it. Pages 3 and 4 of the report is just static text. Pages 1 and 2 have lots of fields in them based on the query it is based on. I have done this in the...

Hi Can someone please help me - what I would like to do is have some fields on a report pre populated by some details a user inputs on a form. The form has a combo box for Religion. On the report I have a list of all religions with a tick box next to each of them. I would like the...

Hi Can someone help me with this please? On a form I have a combo box which has 5 options - Mon - Fri I have a date started field on the form too. What I would like is to query how many of the given days fall between a date range. For example a user selects Monday (it has to be weekday...

Hi Can someone help me with this please - it's pretty simple I think! I have a form called frmPupils, on the form is a tab control called TblCtl15, on the tab control there is a sub form called subPersonalDailySchedule. I have a field on there called TripPrice. What I would like to do is...

Hi Can someone help me with this please? I have a report which I am emailing from a command button. Currently the button opens the report - converts to pdf and then emails (with the outlook warning). The problem is sometimes the outlook warning doesnt not appear in front of other...

Hi Can someone please help me? I am not a VB programmer - i just know the very basics. I am using Stephen Lebans PDF code to create a report which converts into PDF format. Currently the user clicks on a button to preview the report - i have added the following line (in blue) underneath the...

Hi Can someone please help me? I am not a VB programmer - i just know the very basics. I am using Stephen Lebans PDF code to create a report which converts into PDF format. Currently the user clicks on a button to preview the report - i have added the following line (in blue) underneath...

Hi Can someone help me with this please. I have 3 fields in a table - Pupil ID, Date and Price. I have criteria on the date field - between x and x date. What I would like is the sum of the price broken down by Pupil ID between the inputted dates. I have set the Grouping property of...

Hi I have a form where users fill in some date fields and some cost fields. I have added some calculations which makes life easier for them: EG. Cost plus VAT. I would like to save these calculated fields back to the tables. I am aware that this is not great database design but it is...

Hi Please can someone help me with an IIF problem. I have 2 fields on a form: VATRegistered (Yes/No) TotalCost (Currency) If the VATRegistered Field is Yes then I want TotalCost *0.175 if not - then just total cost. Here is the IIF Statement...