Search results

thank you kindly

hi is there a way to abbreviate the day in query? like monday to mon, tuesday to tue etc?

ok, here's what i want to do, i have a list box with data in it, what i want to do is, when i click on new, another set of fields would appear and like hide the other half of the list box till the new data is entered and show the other half again. i think this is doable through subform but can...

how do you propose i do that? i dont need it in a query i need it to be in my form when changes are made and saved.

here's the code i am using. Option Compare Database Option Explicit 'Module name : clsLogin 'Description : This class module deals with the authenication of a user by checking their ' : login details on the user table. 'Developed By : Rob Boyle 'Example : See form...

hello. lately i have been using the getusername (to get the username of the current pc user) to check the username and password. what i want is, to have a log in screen that can let yo type your username and password at the same time recording or storing the current user because i have a form...

hello. i have a tab that has a subform in it. my problem is whenever i load the form, the focus goes to the subform so the top of the tab is not visible, i have to scroll up just so that it would be. there a fix to this? thanks.

hello i was wondering if there was a way with vba that if they press a tab, the focus or the view wont change meaning there is a fixed point where the center would be. also, how is it to write or what function do i use to validate of the record has any data or not? meaning, if the form was...

ok. i have tried bobs thing really is very efficient, but i tried the vbyes and vbno but i have a problem with itnergrating it, because what if the user does nto want to save it? how do i put a stop to the code?

so i have a form with a subform, how do i filter the record using a listbox? i tried doing this Private Sub lstClientList_Click() DoCmd.Requery Forms.[navfrmClient].[NavigationSubform].RecordsetClone.FindFirst "[ClientID] = " & Me![lstClientList] & "" If Not...

how do i make this a yes or no question? like when the msgbox appears it would give the user two choices, yes then sets focus on the save button and no, just undos the changes. or cancels it out.

sorry. i get it, on the forms general declarations. sorry.

cool. so the the general declaration i just type the Dim blnSave as boolean? no underlying code after it?

so basically, if they dont click the save command i made, it wont save? cause that's my dilemma on a project i made back then, the save function was really just a fancy button because even if they move to another form or record, it still saves.

hello. :D what would be the best way to ensure that people save their information? like if they were working on a form with a tab, and they move out of that form in general a message box would pop out, do you want to save your changes? then sets focus to the save button. also, if the press the...

wow cool. but is this usable with date/time stamp? because eventually, when the data becomes bigger we would have to move it to an sql server and those kinds have the zulu time which is pretty nifty being that date/time stamps can have a disastrous effect when the internal clocks are messed up...

well yeah, if i do that, it does work but what am trying to do is this: all records from tblA are related to tblB, what i want to do is query them together and only show the last record from tblB that is related to tblA, so if tblA has 5 records, let say 5 clients, SAM, MARK, JOHN, PETER, CRIS...

yeah, but it only would show the max value for that entire tbl, how would i set it that it would still show all of the clients but only show the max record on the tblrecords? how is max used?

i dont really know how to do this or even how to ask this question but here's what i intend to do, since my last record has a major flaw in it, i figured, there must be another way, i have tried grouping, dlast, dmax almost every other function but cant seem to get it right. basically i have a...

yeah but am getting a paramater value, and the value being asked is the table, cause i wrote it in a query first, i did so: Current: DMax([DateRecorded],[tblRecords])