Code:
switch(+,-,*,/)
Mariostg
Last Activity: Dec 13 '13, 07:31 PM
Joined: Sep 17 '10
Location:
-
Your switch statement must contain the name of the variable against which you want to execute the case statements, not the options you are looking after. -
Leave a comment:
-
We will migrate to 2010 eventually...Leave a comment:
-
Well, month is not a method of worksheetfuncti on object. Look at the autocomplere methods you have available when you type WorksheetFuncti on.m in the VBA window.
But VBA has a month function that expects a date as argument.
Try this
Code:Debug.Print Month(CDate(1 & " " & ActiveSheet.Name))
Leave a comment:
-
@jimatqsi
Just hovering the tables. But nothing slow. In fact one of my database has been in use since 2007, 160 users no problem.
I am just puzzled as to why it does this. It's like if by hovering the table it would open. I read somewhere the max number of open tables is 2048 less internally open tables...
Yeah I guess I got bored and suddenly started to hover lol.
@zmbd
After I realized this,...Leave a comment:
-
Cannot open any more tables.
In Access 2003, I get this message just by hovering on the linked tables in the table window and letting the mouse in place long enough for the link location tip to pop up then move the mouse pointer to the next table.
I am wondering if that is just me. Number of tables hovered is rather inconsistent. Anywhere between 20-60 tables. I tried on 2 different databases and they both do it. I can get subject message to appear by hovering... -
I can't see the link you provided from where I am.
In the past I've done it through VBA which would create HTML(table tags with colspans) or SVG. Access would create the file in question then fire up IE. If you are familiar with any of those (and wants to learn VBA) you can get pretty fancy. Throw in some good CSS and javascript and sky is the limit. First build your html view as a prototype then code it in VBA.
I'm pretty...Leave a comment:
-
Well, the header file should be in a directory that is in your PATH. I doubt your desktop folder is.
Did you install the phidget library? Maybe you chould check the phidgets forum if you did not. http://www.phidgets.com/phorum/Leave a comment:
-
You are probably looking after placeholders ($1, $2) to use the expression you put between parenthesis in your regular expression. Here is an exemple I have in my codes. It takes a line of text, search for numbers having a negative sign at the end and move it at the beginning of the number.
...Code:Function BringForwardNegativeSign(LineToFix As String) As String 'This is to put negative sign in front 6.54- to -6.54 that exist in the DRMIS
Leave a comment:
-
@veni
How familiar are you with the main() function. Use its argc and argv parameters. There are may exemples available in books and on the Internet
http://en.wikipedia.org/wiki/Main_fu...#C_and_C.2B.2B
Why don't you post your main function?...Leave a comment:
-
Check this. I don't think it contains complete solution but it might inspire you and make you realize that web interface is the way to go.
http://bytes.com/topic/access/answer...em-link-access.Leave a comment:
-
Really pascor how much time did you spent researching about your problem? Did you even bother looking at the links that were provided to you? I sincerely believe all replies provided to your queries are fair. There are several exemples on the internet about the nasty things that could happen if you set your current directory in the path. As @Numberwhun
said, if you want it in your path, put it last. It is a wise advise.Leave a comment:
-
Current directory = . (dot). Therefore, include . in your $PATH. PATH (wikipedia). But you have been warned.Leave a comment:
-
I suggest you do a little bit of searching on the topic. It is a security issue. You can modify your $PATH to include the current directory if you want. If you do it, don't do it for root....Leave a comment:
-
Hi twinnyfo
It has been so long, I had to go back to the code to see how I solved it.
Each line of text was right padded with about 250 blank spaces. After I trimmed the lines, it worked ok. It's odd.
Thanks anyway.Leave a comment:
-
This should get you started:
You may need to replace the % character with * in the WHERE clause.Code:SELECT tmp_tbl.columnHeader, InStr([columnHeader],"r:") AS loc, Left([columnheader],[loc]+2) & Mid([columnheader], [loc]+3,6) & "******" & Right([columnheader],2) AS target FROM tmp_tbl WHERE (((tmp_tbl.columnHeader) ALike "%Order number%"));
Leave a comment:
-
@Neopa. I clearly understand you Neopa and I know about the on close repair&compact ability. But in my case, which I guess is different, I don't want to do that on close, but before I run an automated update/manipulation routine. With 160 users, the db does not close ofen.Leave a comment:
-
If it might help a bit on your space issue, you could use the method DBEngine.Compac tDatabase as part of your backup routine.Leave a comment:
-
Oh definitely zmbd. We all expect the OP to post his final solution or an explanation for future reference.Leave a comment:
-
Here is an untested loop that gives another potential solution
Code:Do while not rs.BOF and not rs.EOF //rs is a recordset ordered ASC by ID thisID=rs!ID rs.movenext if thisID + 1<> rs!ID then msgbox "Range Broken between " & thisID & " and " & rs!ID endif Loop
Leave a comment:
No activity results to display
Leave a comment: