Search:
Type: Posts; User: BillBoeBaggins
Search:
Search took 0.05 seconds.
-
Crap. Sorry for the bad advice then OP.
On a non technical note, where is the presentation being shown where you cannot control the printing?
-
Have you Executed your Sproc in you SQL client to make sure it is acting as expected?
-
IMO. Why do client side handling if you don't have to. Use a UNION with the first query returning the "details", and a second returning Your Cat 5 totals?
-
http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
Lots of good info in that link. But this section is what your really after...
Excerpt:
"There are a wide variety of...
-
Actually, I believe the table gets removed as soon as the connection/session is closed.
http://www.tutorialspoint.com/mysql/mysql-temporary-tables.htm
I believe the "master" db owns them, since...
-
Why not use the built in Access functions for dumping data into CSV files?
-
I am not grasping the context.
Which program/workbook is doing the opening?
Which program/workbook macro is supposed to fire that does not?
Can you describe the order of your events and what...
-
Can you make the numbers more reasonable? You know how much you look at census data they don't show 42,000,000 they will show it as 42 stating that the number represents millions. That would be a...
-
What event do you have the code under? Mine fires every time I open any document.
Private Sub Document_Open()
MsgBox "Dude, Test."
End Sub
-
Alright, I could not find how to view the events for a Slide in a presentation so I only got so far... however. I see this event below.
Event PresentationBeforeSave(Pres As Presentation, Cancel...
-
ActiveSheet.Shapes("Picture 31").Select
Selection.ShapeRange.ScaleWidth 1.41, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 1.41, msoFalse, msoScaleFromTopLeft
...
-
So am I reading this right?
If me.field1 Is Null Then Null Else Me.Field1
......
So I take it the field is not true Null it is "", but you want it to be loaded with Null if "". So your Nz is not...
-
I am not entirely sure that the DataGrid fires off "SQL Code" as it does stuff. Perhaps create your own control so you can issue the SQL and track it..?
-
Could you mark this thread Resolved please?
-
Sorry for the late reply.
I am a control freak so I would do pretty much everything in ADO. I would use linked tables for showing limited quick Select/results queries.
I have no proof to...
-
So you want a webpage that access the users CD/DVD drive, indexes the files, then stores them? Is the web server the one with the drive where you will be indexing the files, as I think that is the...
-
Not going to work then. To the best of my knowledge, images are owned by the sheet, not by a cell.
Create a small VB app with an image object that can click and paste into, then a text field for...
-
Identify the event that gets triggered from open via tray and then refer it to the method/event that you trigger upon opening?
-
I have experience with MySQL but I couldn't give you performance comparisons without looking them up. However, there is no network traffic difference between sending an Update command to SQL Server...
-
I am guessing that the cell cannot be an owner of a picture.
What about storing a file path?
-
What is "Nz" is that a custom function or a function I have never seen before?
What errors are you getting, or what is it doing that your not sure why?
Can this "Nz" function accept Null...
-
I agree with Ians. If your already going to the web anyways, might as well make it all web based. Unless of course you have a need/business reason for making it a VB App.
Personally, I like PHP...
-
Log what happens when the Update (or other relevent Event) event is triggered?
-
Alright, so you already know how to get the results, and know how to display them. Now you need to take those results and dump them in another database, correct? Just loop through your dataset and...
-
http://www.file-extensions.org/ndf-file-extension-microsoft-sql-server-secondary-data-file
-
I guess I am not understanding your problem exactly.
Db1/Tb1: User Info, ID field auto number
Db2/Tb1: Billing Info, ID field auto number, user_id number
1. Pull User Info from Excel Top
2....
-
Yep. That would merely be my preference though, if you prefer to store SQL in your code go for it in an Acces environment. If this was compiled code, I would definitely use a Sproc.
That...
-
Alright, so on your User Form, you have 8 displayed records, and you want the information on the form in row 7 to be displayed on row 7 (eight if you include headers) in Excel?
-
Who owns the data stored in Rows 14 +?
You have a loop for the "Preparer" information that leads me to believe that there is multiple people, do they get a copy/ownership of the data in 14+?
-
Yep. Using a Stored Procedure.
Yep. You could display them to the user and show other details for them to confirm the deletion. If you want.
For Access, I would probably (depending on...
-
I am trying to get back into the swing of programming and I whenever I visit Barnes & Nobles I look for books in C# or SQL with an emphasis in MySQL. However, I have a preference for the books that...
-
Is this a script that recreates the tables and then appends the data, or just a raw data dump?
Because if it is a raw data dump, the "settings" your looking for are just where they should be under...
-
Can we see your code where you are utilizing CONVERT?
Is this SQL Server or...?
-
If it was me, I would prefer to actively track what they delete or delete then refresh as they do it. I 120% do not like the idea of removing records from a database based off what is no longer...
-
A thought.. possibly a wrong one. What if the server ran an app to send notifications to the clients when an update happens? So rather then X number of clients bumping against the server at...
-
http://www.vbforums.com/showthread.php?t=395267
-
I gave you code (whoops) in Inline IF format. You need to convert it to your syntax/flow.
-
You are right, not possible. But found a thread for emulating a Control Array in VBA.
Understanding events. IV: A substitute for control arrays in VBA
-
Google: vb.net mouse hook
4th Link.
How to set a hook in Visual Basic .NET
-
Complexity is relative. Windows or Console depends on your purpose.
Start here:
Using the Winsock Control in Client/Server Applications
What are you trying to achieve?
|
Click Here to Expand Forum to Full Width
|