Search results

I have debugged the whole off my vb project & can't find any errors:(

I have an access 2000 database, that is split as an MDB backend and an MDE Front end, it serves approx 30 users and help to control R&D of new products. The database has been running problem free for 18 months, I was recently asked to alter the base task generation and reporting. Unfortunatley...

I implimented the last change you suggested to the save function and also rejigged the re-calculation points in my modules. I have managed to get the module to run 3 times for diffrenet data sets in just under 2 minutes, so I am happy. Thanks for your help

I kind of expected the concatenate to hang as it fills approx 24,000 cells. It is the Opening, Transfering and saving of data to the external CSV that seems to be the problem. I did try something in this vain, but couldnt get it to work Windows(Win1).sheets(Sheet1).Range(A1:DE1000).value...

Public Sub PlannedManufactureCsvUpload() 'UPLOAD PLANNED MANUFACTURE TO COGNOS CSV If MsgBox("Upload Planning Data to Cognos" & vbCrLf & vbLf & "This function will take 3 - 4 min depending...

I need to filter a query via a date range from within a form among with other criteria. I can link the query to combo boxes for certain criteria but could not get it work for the date range I was hoping to do this via VBA & SQL on hitting the filter button to change the query, Hence the FDate...

MStef, unfortunately your suggestion gives me the following error: Runtime error '2342': A RUNSQL action requires an argument consisting of a SQL Statement Any other suggestions would be most welcome

Thanks for the quick response but unfortunately that gives me the following error Compile Error Expected: End of Statement

Ive done a good 4 hours of googling and searching to no avail so would appreciate some direction. I have the following code:- Private Sub Command71_Click() Dim SDate, FDate As Date Me.Text74 = Me.DTPicker7 - 1 SDate = Me.Text74 Me.Text76 = Me.ActiveXCtl68 + 1 FDate = Me.Text76 DoCmd.RunSQL...

The main Entry form post 1 line to a Product table & 1 line to a history Table The append query run on saving the Entry form posts 281 lines to a task list table So I might go temp tables in the FE based on what you have said. Thanks for the advice

Thanks for the quick response. No Everyone is using the same table in the back end Its a steep learning curve, especially when your teaching yourself!! So if I understand you correctly Create Temp holding tables within the FE application (everyone will have there own stand alone FE...

Change your list box option, bring up the properties tab for your list box Ensure that the Column Count option has the same number of columns as the query used to generate the list box. Also then you can hid the columns not used by changing there size in the Column Widths Option, separate your...

A Brief background I have a Projects database to create and track new product development, BE on the server, FE as an MDE application for users I have the following setup within the FE A Form to enter project specifics, i.e customer, product etc Append query on save to create a separate...

I have finally worked out the problem with some records not showing up in queries. As previously stated I have been running an MDE in 03, 07 and Runtime, as I didn't want to spend 3 days setting every terminals Action query warnings to false, I inserted the statment DoCmd.SetWarnings into my...

Just got back into gaming after a 2 - 3 year sabbatical, Had my 360 for 6 weeks now & can't get enough!!!!! I virtually have to be set on fire to relinquish the controller and go to bed! Old School Best: Roland on the Ropes - Amstrad CPC 464 Oh Mummy - Amstrad CPC 464 Sonic -...

Code worked a treat, after some fiddling and adjusting I now have the ability to import multiple files from my server location automatically on opening my application. Well Chuffed, thanks

Thanks for the quick response I will give it a go now and let you know how I get on. :D

Hi some more advice and guidance is needed :) I am in the midst of building an access application to import and sort CSV files generated from plant equipment. I have the files correctly importing into access via VB code. Within the code the file location is selected via an open dialog box...

Below is code attached to convert text to uppercase automatically on entry by user. Just change (Your Control Name) to the name of your text box Private Sub (Your Control Name)_KeyPress(KeyAscii As Integer) Dim strCharacter As String ' Convert ANSI value to character string...

Attached is a link to another post, this is the code I have run in a few of my DB that I have not split and converted to MDE's, scroll through to post 13 http://www.access-programmers.co.uk/forums/showthread.php?t=166911 Should do what you want