Search results

I currently have a .adp file which we use in Access 2007 but still states it is in Access 2000 file format. This file sits on a share where a number of users will use it. Does anyone know if there is a maximum number of users which can open this file at any one time? Sometimes when we try to...

I have got an access database which opens an Excel workbook using the following code: With CreateObject("Excel.Application") .Workbooks.Open "\\stoke\analytic$\Price Increase\MarginRecoveryPlan " & vMonth & "\zPricingExtractManipulation\PricingExtractManipulation-MACRO.xlsm", True .Visible...

I would like to be able to push data into a SQL table using VBA as opposed to the Upsizing Wizard. Is this possible? Kind Regards Carly

I have got an option group on a form with 4 radio buttons. I have then got a query which contains a few fields one of which has a criteria formula as follows...

Hello, I am exporting a table to a text file and I am having a problem with decimal places. I have got a column which is showing a number with differing number of decimal places, between 0 & 3. The column is set to Data Type decimal with auto decimal Places setting. When I export this to a...

I have got multiple controls on a form in Microsoft Access Project which could be a mixture of entries & blank fields (like a selection screen) as follows:Public Function cmdUListOfDelNotes() DoCmd.SetWarnings False Dim cnn As New ADODB.Connection Dim cmd As New ADODB.Command Dim param1 As...

I hope I explain this well enough for someone to understand but please bear with me as I am pretty much a novice at this. I have a query on ADP which is the following SQL Code:SELECT CONVERT(char(10), wcs_entry_date_time, 103) AS Date, LEFT(wcs_container_id, 2) AS Container...

I have created a AutoForm: Tabular and I have got 6 columns. I enter a product code into the 1st column, and when I tab off this column it runs the following code to fill the next 2 columns:Private Sub Product_Code_AfterUpdate() Dim Chk As Variant Chk = DLookup("[description]"...

I have tried the attached code from a previous post http://www.access-programmers.co.uk/forums/showthread.php?t=98727&highlight=table+exists but some of the code doesn't work on Microsoft Access Project. Does anyone have any ideas how I would amend this code so that it works? Regards Carly

I am using the following code in Microsoft Access Project:Docmd.OpenStoredProcedure "Qry F Order Lines Picked", acNormal which works when I run the code, but when another user uses the database it says it cannot find the stored procedure. But it is there!!! Does anyone have any ideas why this...

I have got a form which has on it 2 text boxes formatted to Short Date dd/mm/yyyy (Start and End dates). Is there anyway in which I can format them so that I can enter the date as follows: dd/mm/yyyy hh:mm:ss? Regards Carly

I am using Microsoft Access Project and I have got the following stored procedure which creates a table:ALTER PROCEDURE dbo.[Qry D1 GroupedFail&Success] (@EnterDate1 datetime, @EnterDate2 datetime) AS SELECT CONVERT(char(10), wcs_entry_date_time, 103) AS Date, RTRIM(wcs_zone) AS Zone...

Does anyone know what the maximum rows & columns are for a crosstab query as I cannot find them anywhere? When I create one that is too big, it just gives the message of how many columns I have rather then how many I'm allowed. Any help would be greatly recieved. Regards Carly

I have got a formula in a Query as follows: Suggested Qty: [StockQty]/[Numerator] How do I round this down to the nearest 1? (i.e 7.2 = 7 or 9.9 = 9) Any help would be greatly received. Regards Carly

I would like to force a field to be 2 decimal places in the SQL view of a query as I am creating a UNION. If is there anyway of doing this? I have tried CONVERT() & FORMAT() but I can't seem to get this to work. Any help would be greatfully received. Kind Regards Carly

I have a crosstab query which contains 1 lrow & 4 columns. The column headings are vendor numbers & the value is Sales. I would like to sort the crosstab by the value rather that the column headings so that the greater value is at the start but it is automatically sorting the columns into...

I have got a query which runs to create a table containing Vendor Number & 12 Months Sales for the Top 4 Vendors. What I then need to do is create another query which does exactly the same as the above but for all other vendors apart from the 4 in the above table. The vendors will always be...

:confused: I am currently using the following Select Case Statement Dim Id As String Id = DLookup("signedoff", "Check") Select Case Id Case "X" Me.RunMacro.SetFocus Case Is <> "X" MsgBox ("This vendor has not been signed off for the selected period.") Me.Period.SetFocus...

I currently have a textbox on a form which is linked to a query by [Forms]![FrontPage]![ProductGroup]. What I want to do is enter multiple entries into this textbox so that the query will run for more than one product group? i.e. Like typing in 33 or 43 or 45 etc into the criteria row in a...

I currently enter a date into a text box in a form in the following format: 200401 = Jan2004 From this I would like to work out a future date which will always be the end of February or the end of August depending on which month I am reporting on. I have done this for August by using the...