Search results

Thanks for your response. To be honest, I didn't know you could split a database and have a front end for multiple users, but there is no way that this database in its current format can be amended. Everything I know is self taught so I am a little blind to some things that may have been easier...

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...

This has been completely answered on the other forum: Call Shell("Excel.EXE ""\\stoke\analytic$\Price Increase\MarginRecoveryPlan " & vMonth & "\zPricingExtractManipulation\PricingExtractManipulation-MACRO.xlsm""", vbNormalFocus)

This has been partly answered here: http://www.utteraccess.com/forum/Open-Workbook-Access-Pro-t1968726.html However, if anyone knows how to get around the future proofing problem, then please let me know.

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...

Thanks for the replies...all I need to do what the following, I didnt need to upsize everytime... CurrentDb.Execute "DELETE FROM [ODBC;Driver=SQL Server;Server=Hornbill2;DATABASE=Business Intelligence;Trusted_Connection=Yes].dbo.zCustomerDataMaster", dbSeeChanges CurrentDb.Execute "INSERT INTO...

I wouldnt say I was fluent in either, but I do know quite a lot of both. I guess by your response it means there is no easy way of just running through the wizard in VBA? Kind Regards Carly

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

You say you did it differently & "" worked, please could you let me know how you did it...my formula is like this: IIf([Forms]![frm:salesinfo]![frame31].[value]=1,"",IIf([Forms]![frm:salesinfo]![frame31].[value]=2,"01",IIf([Forms]![frm:salesinfo]![frame31].[value]=3,"02","03"))) but it just...

That doesn't work either.

When I change it to Is Null I get the following message: "This expression is type incorrectly, or is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables"

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 amended the code to the following:Dim str1, str2 As String On Error GoTo str1Detected str1 = DLookup("[wcs_sequence]", "[tbl T Number of Seconds Logged On]") str1Detected: If Err.Number = 208 Then MsgBox "Table Does Not Exist" Else DoCmd.RunSQL ("DROP TABLE [tbl T...

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...

Thanks a lot...