Search results

Hi all, I have a continuous sub-form -- on the main form I want to put a button, that when clicked goes to or sets the focus to the fifth record in the sub-form, how would I do that please? Regards Melt

Hi All, Are there any known issues with Access 2007(SP2) and Windows 7. I have an app that performs great on Win XP/ Access 2007 and dire on Windows 7. Forms take ages to come up and now I have the following query which won't even run on Windows 7. The code below returns about 1,500 records...

Thanks a lot ajetrumpet, that works great, problem solved. Regards Melt

Thanks to ajetrumpet for the solution to this problem, setting the AUTOEXPAND property under the DATA tab to 'off' fixes this problem. Regards Melt

It relates to this problem I'm having. http://www.access-programmers.co.uk/forums/showthread.php?t=191505 Regards Melt

Hi all, Can anyone tell me how I might programmatically mimic the user putting their finger on the shift key? Regards Melt

OK, thanks, might put up another question for that. Regards Melt

Hi SOS, Do you know how I might mimic the user putting their finger on the shift key programmatically when they begin to type in the combo? Regards Melt

I'm using Access 2007 SP2 on my home PC. This doesn't make any sense to me how so many PC's show the error and you're not seeing it. Thanks for your input. Can anyone else confirm it's working please? Regards Melt

SOS, did you download my sample db, there is an ID in there as well, which I hadn't included in my typed sample data. Regards Melt

I tested this using Access 2003 and 2007 versions, both give the same buggy result on my clients machines and home dev machine. Sorry, where is the Office service pack info? Regards Melt

Hi all, Struggling with what seems to be a bug in the combo box. Given the list of values below in a dropdown combo, I should be able to start typing a name 'IADT' and the combo should jump to the name I want as I'm typing. However in the list below that doesn't happen for some reason. As a...

Hi guys, thanks for the replies. Thanks lagbolt your solution works fine DCount("*", "qryCountRepRecs1"), I wasn't aware I could feed a query into a DCount, problem solved Thanks for your input Brian Regards Melt

Hi all, I have the following code which counts up the records in a particular query. How can I run this code from my form and stick the count value returned into a textbox. SELECT Count(qryCountRepRecs1.RepsRecordsID) AS CountOfRepsRecordsID FROM qryCountRepRecs1; I can't use DCount as...

Hi all, I have a secured DB set up with user and groups, I'm having a problem where one particular group are not being sent to the startup form but are being sent to the back end instead, albeit with no access to any tables or forms. I've checked the permissions and they seem to have all the...

OK, thanks for that Bob. Regards Melt

Hi all, I have a form and i need to disable edits like so: Me.AllowEdits = False The problem is, it also seems to disable my toggle button, the code in the click event doesn't fire after I've set Me.AllowEdits = False. Command button are uneffected. Is there a solution to this problem...

I had thought of that as a last option. I was hopeing there might be some other option that could be applied at the form level. Thanks for the reply Melt

Hi all, I need to lock records where the order date is more than three days old. I know I can do that with the OnCurrent event, setting it to Me.AllowEdits = False when needed. The problem with Me.AllowEdits = False is that the button/controls cannot receive other updates or instruction...

Hi all, How do i prompt user for their sql server login details? I've been asked to create a 'default' account, so it's not tied to windows authentication. I've set up the sql server login. I relinked my tables as follows: I created a new DSN and chose the option to use Sql server login...