Hi, I'm what you'd consider a visual c# newbie, as well as just starting out in oop programming.
I need help or a point in the right direction in achieving the following:
I have designed the following database tables which will be used to manage Users/Groups/Permissions throughout my client...
hi jimbopalmer,
ordernums are unique only for each accntnum
cable and/or pair are optional, but I must show them if they are.
Order by is not necessary, as i will use ms access to further manipulate the file.
Thanks,
THEGREEK
hi guys,
thanx for all the responses much appreciated, I still have a problem all methods posted above seem to work..but I think the problem lies in that the table that I'm querying has like 40+ million records :(
so I thik the any group by(distinct query) will take 7000 years to complete :)...
Hi,
I was just wondering if someone could help me out...I can't get by this roadblock.
This is a sample of my source data:
(Note this is just a sample..my real data has like thousands & thousands of records to work with)
AccntNum OrderNum Param ParamValue
-------- -------- -----...
Thanks for the info...
Much appreciated.
Is there anyway using the syntax you showed my above, can I check to see out of the two radio buttons..which one was selected?
Thanks again,
If you need any more info let me know.
I would like to replace the below:
If Document.Form.CTRL_NAME1(0).Checked = True Then
I would like to substitute a variable "x" where the 1 currently is
Does anyone know the right syntax to use?
Any help would be greatly appreciated.
Thanks in advance,
try this on your date range criteria,
WHERE [Your Date Field] >= Date()-1 And [Your Date Field] < Date()
...this syntax WILL give you yesterday only...the reason for the above syntax....date()-1 will not work because of the DATE/TIME factor
if the field you're querying is a date/time field...
Hi,
I've tried unregistering the comctl32.ocx file, both with regsvr32.exe and access' built in utility, but it keeps telling me that I need a separate setup utility to uninstall/unregister comctl32.ocx. can someone point me in the right direction, I'm not able to deploy my application because...
Hi,
I've developed an MS Access .mde file, I've used the following: (MS ListView Control (5.0), MS StatusBar Control (5.0), MS ProgressBar Control (5.0)) -- [comctl32.ocx]. The problem I'm having is that this setup of my application works fine on some pc's, but yet on others when it is opened...
Hi,
I was just wondering if this is even possible, for example on startup, If I were to create a form that checks to see what active security file (*.mdw) if any, was used to access that session of the application? If the user did not login using the correct security file, auto kick him & shut...
Hi,
I was wondering if it was possible to change for example under tools, options... I want to change under the 'Keyboard' Tab - 'Behaviour when entering field option group' to always be "GO TO END OF FIELD". Is this even possible, if so can i get a sample piece of code to illustrate...
Hi everyone,
Is there anyway to detect which user currently has a certain record open (let's call the user "JSMITH"). Ideally I would like; when a user opens a form with an underlying record based on it. The OTHER user that now tries to access that same record gets something like a...
I was wondering if anyone could point me in the right direction regarding refreshing an iFrame (in-line frame) as part of a page at any given interval. Note I would only like the iFrame portion to REFRESH, not the whole page.
Thanks in advance,
THEGREEK
Hi,
I was wondering if it was at all possible to refresh certain part of a webpage at a specified interval. I'm desperately trying to avoid from the user to having to refresh the whole page to view the required info.
Does anyone know if this is at all possible?
Thanks in advance,
THEGREEK
Hi,
I was wondering if it was at all possible to refresh certain part of a webpage at a specified interval. I'm desperately trying to avoid from the user to having to refresh the whole page to view the required info.
Does anyone know if this is at all possible?
Thanks in advance,
THEGREEK
Hi,
I've looked everywhere on the net, BUT all I can find are tips on how to connect to an MS Access & MS SQL Server backend db's.
I was wondering if anyone can point me in the right direction, or if anyone has the syntax for writing a dsn-less connection to a SYBASE DATABASE.
Thanks in advance,
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.