Hi,
Just moving part of our Access 2003 app to 2007.
When I try to open an Access 2003 ADP in 2007, it just hangs, with an egg-timer cursor.
Any clues??
TIA
Steve
cyberdwarf
Last Activity: Nov 19 '08, 09:41 AM
Joined: Nov 3 '06
Location: Andover, Hants, UK
-
Sorry Jeff
Using WinXP Pro -
Deploy .NET 2 Windows form app
Hi all,
Sorry about the cross-post!
I am new to this area, so please bear with the dumb questions!!- I have written a windows form app which is designed to run as an EXE under the .NET 2 framework;
- I have used the OneClick publishing wizard to publish the app;
- Everything works & deploys OK on my development PC;
- Installation runs OK on a different PC, BUT....
- Running the app produces a Microsoft security error.
-
Deploying .NET 2 windows form app
Hi all,
I am new to this area, so please bear with the dumb questions!!- I have written a windows form app which is designed to run as an EXE under the .NET 2 framework;
- I have used the OneClick publishing wizard to publish the app;
- Everything works & deploys OK on my development PC;
- Installation runs OK on a different PC, BUT....
- Running the app produces a Microsoft security error.
-
Hi
Do you just want to draw a box around the multiple text boxes?
If so, you can use the LINE method in the Print event of a report section.
HTH
SteveLeave a comment:
-
FWIW
Maybe you could place the 'Advanced' controls on a hidden Tab/Page on the main form. That way, clicking the Advanced button would just make the hidden Page visible and switch focus .
HTH
SteveLeave a comment:
-
Hi,
Try adding a WHERE clause to the controlsource of the Parts combo, egYou should be able to adapt this to your needs.Code:Select PartId, PartName From tblParts Where StockTotal > 0
HTH
SteveLeave a comment:
-
Does the first form save data to your datatables? If so, you can immediately look up the saved data on subsequent forms.
Does the first form open other forms? (eg, user presses a button). In this case, there will be VBA code behind the button Click event and this will contain the code to open the next form"ValueToPas s" can be a literal string, or a variable name....Code:DoCmd.OpenForm "NextForm", acNormal, , , , ,ValueToPass
Leave a comment:
-
If that means 400Mb, then I'm not surprised. In fact I'm surprised Access has not already choked on that size of peanut!
SteveLeave a comment:
-
cyberdwarf replied to trying to use access to open an excel spreadsheet when 2 versions of excel are in usein AccessSomething like this might be more useful (I assume that the Excel installation path might be changed from the default and therefore not prove to be so reliable):-SteveCode:Dim objExcel As Excel.Application, strExcelPath As String Set objExcel = New Excel.Application Debug.Print objExcel.Version Set objExcel = Nothing
Leave a comment:
-
An HTML doc is just a text file: there's no reason you shouldn't be able to write out to one.
Is the HTML doc opened by another user?
SteveLeave a comment:
-
You can pass data from one form to another in several ways- Using the OpenArgs parameter of the DoCmd.OpenForm command, then using Me.OpenArgs in the load event of the opened form;
- You can retrieve data held on another form, using something like:-Code:
MyValue = Forms!FormWithData.ScreenFieldname
- Any data saved to a table will be immediately available.
SteveLeave a comment:
-
wouldn't dare to send a knight out on a dog like that ;-)
SteveLeave a comment:
-
You should be able to pass the User's selection to the opened form by using the OpenArgs argument to DoCmd.OpenForm.
This value can be picked up in the OnLoad event of the opened form, eg:-The UserChoice variable may now be used to build your controlsource, or for any other purposes.Code:Private UserChoice As Variant Private Sub Form_Load() UserChoice = Me.OpenArgs End Sub
HTH
Stev...Leave a comment:
-
Hi
My understanding is that you need to have some image editing software installed, to active as the OLE server.
Yup, it was a big PITA when MS dropped their app. However, I have found that any decent image software should be OK (IrfanView works well & is FREE!)
HTH
SteveLeave a comment:
-
If this is an application developed in 2003, then you won't be able to run it in Access2k, unless you have the 2003 runtime loaded.
SteveLeave a comment:
-
Hi
You can use:-HTHCode:Forms!MyFormName.Move 0, 0
SteveLeave a comment:
-
Try checking the error log.
Sounds as if Access is having problems coping with either your application, or maybe with somethiong in memory.
HTH
SteveLeave a comment:
-
Sanka
Did you read the reply to your previous thread? Was it any help?
http://www.thescripts.com/forum/thread714143.html
Have you tried the Shell command?Steve...Code:RetVal = Shell[b]([/b]"Macro to run"[b],[/b] 1)
Leave a comment:
-
The basic routine is:-HTHCode:Dim RsDetails As New RecordsetDim SQL As String SQL = "Select * from MyTable" RsDetails.Open SQL, CurrentProject.Connection Do Until RsDetails.EOF Debug.Print RsDetails("Field1") Debug.Print RsDetails("Field2") RsDetails.MoveNext Loop RsDetails.Close Set RsDetails = Nothing
SteveLeave a comment:
No activity results to display
Leave a comment: