Search results

Hi Guys, having a wee bit of bother with a select case statement handling a numeric range of values. Basically I’ve quite a bit of data that needs to be summarised. Per record, where each record could have 20 to 2000 readings with the same record number. There is a range, First Range: < -0.1...

Hi all, I have a simple enough frame with four option check boxes within the Frame. It works fine, if the user selects a value within the frame it returns a value of 1 – 4 If they leave the frame with no values selected (which is the default, showing that this item is of no relevance to the...

Hi everyone. I have hit a wee issue with an Irish name that I have just never even thought of before. The UserName is "G O'Conner" and I have a bit of VB that filters for a user along these lines Dim strName as String Dim strUserName as String strUserName = "G O'Conner" 'Function to get...

I think the answer for this will be "no" but I will try anyway. Can you create an Access 2000 .mde from Access 2007? I know you can't from Access 2003 (which is what I am running at the moment.) Thanks for any help guys. :)

Hi Guys This is a question that someone my be able to help me with. If I ship a Access_2003.mde app to a client, what licence (if any) would I need to ship Access 2003 Run-time with the application? From the MS Web Site, I'm not sure if I need developers licence. I have a developers licence...

Hi Guys Work have just issued me with a new laptop, a very nice and speedy Dell. But, I just got it yesterday and will be swapping data from my old laptop today. I am running Access 2K as I support these applications for the Branch. The issue is while checking to ensure that A2K was installed...

Hi All I have been given a db that was converted up to Acc2003 and then converted back down to Acc2K, because of this you can't view the Database Properties information in the File > Database Properties menu. An Error Pops "[Database Name] is unable to load the database properties". The issue...

Didn't seem to be a place to share "Interesting Things" so started a new one. Mayday Mayday :D

Could anyone point me to Download Site where I could point my users for Access 2003 Runtime. I am having trouble finding a fast download site from here in New Zealand. Thanks for any help :)

TOTALY overjoyed. New Zealand rugby league team, the "The Kiwi's" take on an beat Australia at home to win the world championship 34 - 20. This is massive, the wizard's of Oz should beat us just about every time with the depth of talent they have. So well done boys...

Hey All Same database as my other Multi Select List Box. But I did a update to the code and added a new button, the new code uses a "in(1,3,6)" statement in the SQL instead of a "Or". So it's a bit cleaner and faster. So you have both sets of code behind. Hope it helps. :)

Hi This is my example of selecting multiple items in a list box and doing something with them. In this example running a report based on the items selected. I know there are other examples out there. Hope this helps :)

Just a little help if anyone has the time and this wee project can be put to bed. I am trying to create a function that will loop through my tables and select only those that are LINKED TABLES. This I think I have done with the below code. (Unfinished) which tells me which of my tables are...

Hey guys. Think I just need a fresh set of eyes on this one, because I just can’t see what I am doing wrong. :confused: Basically it’s just you average dynamic buttons. If it’s the first record hide the previous and first buttons. And if it’s the last record or new hide the Next and new...

Hey guys. Well this is a new on for me, the idea is this. By using a datasheet view in a subform and a custom popup menu I can allow users to filter down to the records they wish to view, in whatever order they want, and then allow them to open/edit said records with a Double-Click Event...

Hey all. I am to work on a project in the New Year using Access 03 and the MSDE “back end” instead of Jet. This will be a jump for me, I have “backed” Access systems into SQL Server using ODBC but I have little experience with MSDE. So my question is this. Before I go and start “trolling” the...

Hi Guys Have a spot of bother with a format function in a 97-db report that I am Fixing. I was asked if I could fix some reports that have never worked, I opened them up and had a look. The field had the following code. =”Payment No “& [PaymentNo] &”until “& Format([PayDate],”Long Date”) Also...

Right got another for you all. This time I am trying to use an option group in a subform. If the user selects [On_Going] I would like the date/time field [dtmBYWHEN] to be disabled. And, conversely, if the [Limited Time] option is selected, [dtmBYEWHEN] will be enabled. To be honest visable =...

Cascading ComboBox Subform Error. Right I am stuck, and I hope someone out there can help. I have a main form and a sub form. The subform is a form. On this sub form, when I put the form together before linking/inserting onto the main form, I set up your classic Cascading Combo Box, select the...

They have the girls in Admin working with two database’s. One is run through Access97 runtime from a .mde database front end. The second, newer database, is the same in may respects. It’s a mde front end, except its written in Access2K and they would like to use the 2K runtime to operate it...