Search:
Type: Posts; User: Ecniv
Search:
Search took 1.35 seconds; generated 46 minute(s) ago.
-
Why vba?
Surely you'd just drag it.. much faster than vba...
Probably you'd need the two to be aligned and either see if there is a center method (or something similar) or do a load of...
-
straight out of stack overflow
-
Nevermind - got it... My vba had errored... works fine ('macros'!macroname(cellref) )
-
Hi
I have a macro in one workbook. I want to run it via cells function (=xxxxx(cellref) ) but because it is in another workbook excel cannot see it.
Whats the way to specify to call it from...
-
after you .send I think there is an extra option to force a resend. Check the application force refresh or send.
-
Interesting problem. Doubt this is what you want, but does seem to work (text 3 digits as you specified). Perhaps it will give you some ideas
Public Sub t()
Dim sht As Worksheet
Dim...
-
Hi
Have a look at css in combination with a checkbox (you style the label, the checkbox gets hidden) and the css can depend on the state of the check box loading one or the other image...
If you...
-
Wouldnt you just do the subquery and filter the results as required ?
Why sql Access on an xls ?
If you need all totals and a separate column of this month, or just this month, you could do a sub...
-
Hi
Dabbling with the web based tech... and thinking that Python the current band wagon...
But unlike just running it direct, I am running it on my laptiop running IIS server.
Configured the...
-
Use the thread options to mark as complete
Probably caused by you sending an insert query as the recordset. instead of opening a recordset of the data (and executing the insert).
-
I've not used it in that way before...
In theory you may be able to write to an image (possibly just in memory) and show the image on the form.
Possibly you can use the web explorer control to...
-
Or change to a while loop ? (checking current row vs end row variable that you have - and maybe add in a max iterations (100k))
-
Are all office installations the 32 bit?
Check the references on one that works and one that doesnt to see if there is another problem; may be one is using an older ado/dao than the others?
Is it...
-
Ok.....
But the other person gave you the code.. havent tested it, but should work.
Its working by getting the link that the user clicks, finds the first image (img) child it finds and just...
-
One option - for putting into the open sheet.
In vb use objects pointed to the MS Access and MS Excel.
Open your data in the access (recordset), loop read and write it into the ms excel sheet...
-
<html>
<head>
<script type="text/javascript" id="scriptJS">
function teste(){
alert('boo');
}
function resizeCombo(o){
var chs = o.children.length;
for( var i = 0; i<chs; i++ ){
-
Hi
I dont think so. Perhaps an addition browser specific, or perhaps you can replace the dropdown/list with custom divs and JS (display and ajax).
But if it auto expanded, it might pop out of...
-
no idea... what did you change?
possibly its the img you are setting or trying to set
var img = $('<img width="100px;" height=" 100px">');
creates an empty image.
-
Hi
Just an update.
I had to put the jxl output into a bytearrayoutput (so it would continue working) then feed this into the http output stream via a new string wrapped around the...
-
Hi
Got a weird one here. Probably just me though.
Work has a button to take data from a db and put it into an xls file using javas jxl.
Now, it works but is generating an underlying error...
-
Depends on space and which db you use.
In MS Access I used 'created by'/on 'updated by'/on (two fields each) to get the last date updated and when it was created and by whom.
However you could also...
-
Depending on how run the queries, you could grab the sql of the query and add in the where clause as applicable.
Or re-edit to use parameters (as west conn1 said) and always pass the variables -...
-
When you save... via vb, can you parse the 'id'.
If so then add 's' + origin+'pk'+pk then when saving parse the string 'id' and add to the columns as required...?
Same thing for the sql driving the...
-
no problem.
If this resolves the question, at the top of your original post should be a thread tools. Select it and select mark as resolve :)
Have a great day!
-
open both workbooks
vlookup
combine if and iserror to replace if not found
if you want to do this in code... what have you got ?
Pretty sure there are some sticky posts at the top of the forum...
-
Select the lot.
Use the excel function transpose
A quick google search gave the link above...
-
@westconn1
I opened the spreadsheet, tested and got the same result as op.
Looks like Excel is not evalulating the data as you/I would expect.
Like the linked I posted, added a concatenated...
-
Possibly one is text and one is numerics. Different but look the same...
edit:
found this link online, might be useful.
-
Its on Tomcat (Jsp).
It looks like the browser is working, but js scripts and the new dom elements cannot be seen after the ajax call. Which is strange. I'll keep going, thanks for the suggestions
-
Doesnt your user defined function work with ranges?
Ie pass the values of the range to the function to retrieve the values.
Or is it that your function isnt auto running when it receives new...
-
Hi
For the company I work for, I have some HTML being generated and inserted via AJAX (I think).
Problem is that the new elements cannot be found via document.getElementByID nor JQuery...
-
Set HTMLInputs = HTMLDoc.getElementsByClassName
For Each HTMLInput In HTMLInputs
Debug.Print "ClassName:" & HTMLInput.className, "TagName:" & HTMLInput.tagName, "ID:" & HTMLInput.Id, "InnerText:" &...
-
Same here. I thought I had replied yesterday but guess i didn't...
You need to revisit the structure and read up on normalization.
The thoughts I had were to do with one product having variations...
-
The thing with db desing is that there are many ways to complete something. Some have advantages over others (eg speed or easiness to see or flexibility).
I would advise that you try as many...
-
Why are you still using Access 97 mdb?
If you can get to 2007/2013 you should have lots more to play with.
free ms Access 2016 Runtime
Not sure you can use this to create mdb/accdb files. But...
-
The problem is that to search for null - you need to change the where clause sql....
WHERE conArchive > #" & ArchiveDate & "#"
to
WHERE conArchive IS NULL
-
@vb6forever
Strange as I made that sql in an Access db and it ran (v2019).
What error message did you get?
tblTest
id - pk auto number
vlr - number double
tblStatRanges
IDRange pk...
-
As a probably pointless waste of time I made the following... But obviously isnt what you need at the moment
SELECT
sr.fldLabel,
COUNT(sq.id) AS theTotal
FROM tblStatRanges sr
LEFT JOIN...
-
re Post#23
Just to point out that in Access VBA (at least up to 2013) you can create a vba function pointed to a global variable (possible use a static variable in the function) and call the...
-
Is this Access ?
I havent looked at the coding but you are probably running an sql statement. Possibly pre defined perhaps built via string.
If the latter, then you will be needing to add the...
|
Click Here to Expand Forum to Full Width
|