Search results

i have a form that adds some value into the database once a button is pressed. The value comes from a field that I want to clear after the value has been inserted. I have no idea what is wrong with the code but it doesnt clear the box. heres the two pieces of code I am using... Private...

I actually think its the access program itself, I dont know why but the application has ground to a halt. It takes 5 minutes to open and the application often crashes when closing or opening a database -.-

It may be that the computers used are slow but I am trying to improve the speed of the loading of a access database. Is there any specifics that could make the database slower? anything specific in forms or queries? the access application I am using is the 2007 version. thanks in advance...

So... I am again left to look with the issue of: "The expression MouseMove you entered as the event property setting produced the following error: There was an error loading an ActiveX control on one of your forms or reports" I have an active X control on my program (a loading bar sort of...

yes... but the date picker isnt as good if you also need to type in a time too. the users get given a date which they must enter (they use the date and time stamps of an email as reference) In this situation to type in 06/12/12 2:51 the user just types 061212251 the / and " " is...

The value of the field isnt "now" its whatever the user records... the times and dates are not just the time and date now (it doesnt fill the box with anything anyway) but this doesnt give an input mask so you are still relying on people to keep the same date format... the Input mask is still...

I have a field that requires a full date including a time stamp. ie. 05/12/12 14:20 the Input Mask i have used is: 00/00/00\ 00:00;0;_ There are a few issues I have with it... firstly, when I try to change the value (after I have de-selected from the cell once already) by for example...

I am trying to get some logic to work. If a cell has I entered, the cell MUST have another sectioned entered in order to write to the database, If (strDataType = "I") And (IsNull(cmbPASCode.Value) = False) Then If UpdateFlag <> False Then UpdateFlag = False MsgBox ("If the data is...

If (IsNull(NewSupplier.Value) = False) And (NewSupplier <> "") Then NewSuppl = NewSupplier.Value Else MsgBox "New Supplier Box cannot be blank.", vbExclamation Exit Sub In this instance its an either or, so I dont think I need to use cancel but.... if its not "else" it will continue...

i have a few questions about how this works. say i have the name "Penfold1992" already present. why does it flag up "penfold1992" and "pENfOlD1992" why does it ignore caps? also instead of "Cancel = True" can i not just use... "Exit Sub" that will be fine in my case.

i have a few questions about this hopefully not too difficult. what exactly does "Nz(diffFactor,"d")" do? I dont know what Nz is... also, "newDate2Diff" does this need a: dim newDate2Diff as string but also it appears this should be the correct syntax: newDate2Diff = TestDates("n",strDateComp...

nDate2Diff = TestDates(strDateComp, strAuthourisedDateTime) If (nDate2Diff >= 0) Then MsgBox ("Completion date can not be before Authorised Date.") strDateComp = Null strDateComplete = "NULL" InsertFlag = False End If Function TestDates(pDate1 As Date, pDate2 As Date) As Long TestDates...

I would like to check if one date is before another date the date formats i have is currently DD:MM:YY HH:MM I could use CDate but this only checks to see if the day is different rather then the minute. for example when i put these two dates in... CDate(03/12/2012 16:15) - CDate(03/12/2012...

this is exactly what I wanted thank you. I just wondered where is the logic behind what column it actually enters in the combo box when you click on a option? How is it deciding what to put in the box whether it is "ID" or "Name" also what if my table looked like... IN/OUT ID...

I have a form that allows me to insert a value into a table. the table holds names of people. If the user wishes to insert a value into the table, id there to be a check to see if this value is already present. im not exactly sure what the syntax of the code is but Im assuming i would use...

I have a main form which requires users to fill in their ID number in order to create a new entry into the database. ID numbers are stored in a table that has two columns: ID Name This is so that I can match up the ID to their name when they enter in a new entry. I currently have a...

thanks this worked exactly how I wanted it. one question, what is "Me" as a command? what does it actually refer to and is there any cases when i SHOULD or SHOULD NOT use it.

Currently when I tab select a combo box, i have to type something in and use the recognition ability to see what options I have. Is there a way to (once tab selected) use the down arrows to open the box and start selecting options?

why does this contain 2 i's =LCase(IIf(IsNull([User_Forename]),[User_Surname],[User_Forename] & [User_Surname])) aaaaaaa^

I am confused as to what you are trying to do. you have a table with two name columns; First and Last name. you want to create a form that connects the first and last names? I dont know where your input is though... i.e. what name actually appears when you load the form. however in your second...