Recent content by JoseSharp

Hi, I am trying to automate the options that appear in a drop down box. For Example if the user is an Approver (1) then I what them to see only Approver option in the drop down and if they are a Normal User (0) then, again, they would only see what is relevant to them. Below is the code I have...

Hi, I am using a Dbs to report information to excel. The users want the excel workbooks formated. On each worksheet's code I have page set up coding but only the first page works the remaining two are not formated. The code is: 'change page setup .PageSetup.Orientation = xlLandscape...

Hi, I am using the Dbs to report information to excel. The users want the excel workbooks formated. On each worksheet I have page set up coding but only the first page works the remaining two are not formated. The code is: 'change page setup .PageSetup.Orientation =...

Hi all, when exporting a query to Excel is it possible to perform page set up controls to the Excel sheet? Or will I need to create VBA page set up controls with in a Set objXL = New Excel.Application??:confused: :confused: :confused:

Hi all, I have a d'base that performs calculations within queries. These queries are formated to show amounts with only two decimal places. Within the process there are VBA controls surrounding these calcualtions. The controls are not working due to the VBA showing an unformated calculation...

Hi all, I use a d'base that exports a table via a query to Excel. Once the user hits the button to run this command it can take between 30 sec to 60 sec until the data is displayed in excel. Does anyone know of anyway to speed this process up. Currently there are around 12,000 records with...

Hi all, any help welcome with this one. I have some code that currently works with my MS Access D'base. The user highlights data within a list box and the cells above are populated with the users selection. Now I have moved the D'base to SQL and the code no longer works. I was wondering if...

:confused: :confused: :confused: Hi, I have recently transfered an MS Access d'base to SQL. Within the original MS d'base there was a list box that allowed users to select d'base entries and the details of the selection where then displayled. The code was ynListSel = True Dim rs As Object...

:confused: Hi, I have recently transfered an MS Access d'base to SQL. Within the original MS d'base there was a list box that allowed users to select d'base entries and the details of the selection where then displayled. The code was ynListSel = True Dim rs As Object With frm...

Excellent thanks!!! :) :) :) :) :) :) :) :) :cool:

This may help Open your table in design view and and a new field called AddDate set the field type as Date/Time then set the default value as Now(). This will add the time and date to each new entry thus allowing you to run a query using the First search option. Hope this helps Ps the same...

Would this help :confused: 'save strFile = "file name" strOutFile = "c:\access info\forms\" + strFile + ".doc" 'delete if file already exits If Dir(strOutFile) > "" Then VBA.Kill (strOutFile) End If docmd.exit

:( Hi, I have an if statement that dose not recognise if a combo box is blank or not. There are three types of code that I have tried: If !F34 = 0 And !Report = "Domestic" Then If !Combo70 Is Null Then If !F34 = 0 And !Report = "Domestic" Then If...

:) :) :) :) Thanks Pat, great bit of code which has really helped me out :) :) :) :)

With MS Access 2000 I am outputing information in excel via an email. Within the excel file name I need to to enter a Company Number. The CN is part of the data and is retreivable via a select query. My questions is how to I get the CN in the saved name of the file/attachement? Below is some...