Search results

How to convert this string of text that is formatted yyyymmddhhnnss to hh:nn? I can do the mid function to extract the hhnn out, but have a hard time with the rest.

Thanks, ByteMyzer for the link. That code sure seems convoluted. I may give that a try. Ari, I was hoping your code would work. Maybe it's my computer, but your code does the same thing. The form would go page up and down, but at the same time, it toggles the num lock.

ByteMyzer, I see your response to my email, but somehow it's not posted here. I'm not sure if I'm missing something, but your suggestion goes down one record at a time only? What is the common practice out there to go to the second page on a continuous form? Everywhere I search, it seems...

Hi, These buttons with SendKeys functions for page up and page down were working fine yesterday, but today, when they are pressed, the are changing the Num Lock. Very strange. Below are the codes I used for page up and page down. Has anyone experience this before or have any idea why this is...

No, I cannot. I believe number/or date data type must be set to 0.

I have a date field that stores time based on a calculation or based on what the user chooses from a combo box. I use a global variable to store that time and updates a table. At the end of the sequence, I set the variable to 0. In some occasions, the users do not have to choose the time...

That worked great. Thanks.

Hi, I'm having a hard time figuring out the exact syntax for the below dlookup function. When I separate the criteria individually, I get a result, but when I combine the two, I get run-time error of Type Mismatch. strTableID is a string variable

It's too big. I would have to strip it down to post, but I abandoned sending the selected address to another text field. I ended up changing the color of the text box of the record selected, so that user knows that their address has been selected.

OK. My celebration was short-lived. It's not working again, and I think I may discover the problem, but I do not have the solution for it. txtSelectedAddress will requery only when there's an record shown in the form, regardless if I select that record. When there's no record, it cannot be...

No, txtNewAddress was an unbound text box the entire time. It is meant for user to enter a new address if no matching records where found from a telephone number entered in another from. I think something similar may have happened to me before, but it was due to the label not being visible...

If I understand you correctly, I believe what you're saying is true if we are referring to the same button. There are actually two different buttons. One is next to the records if the form returns result from a query. The other button is next to txtNewAddress, which is a textbox that allow...

In the module section, not within the form. If I call this function somewhere else, it will be available.

I have a continuous form that is bound to a table. I have a button in the records, so that when a record is selected, a text box (txtAddressSelected) at the footer becomes visible and is filled with the data from the record selected. The control source of the text box is a function, which is...

I am about 2/3 done with my application, but during of it, I keep losing the global variable when I come across errors. After some research, it would appear that instead of declaring a global variable and use functions everywhere, I should have started the entire process using TempVars. I...

I have several pop up forms that can be opened with predefined locations of the screen at the same time. Due to space, some may overlap each other a bit. Is there a property somewhere I can indicate which form would have higher precedence, so that certain forms are on top of the others when...

I am able to display Chinese characters in buttons, text boxes, labels, but I cannot display them on MsgBox, or include as string in VBA. Is this a Windows or Access setting that I need to adjust?

The error was caused by the criteria of "Is not null". When I removed it, the query worked fine, but it would append blank data. That is what I'm trying to prevent. Maybe I'm not resetting the variable correctly. After certain events, I set all the variables that feed the said functions to...

Is Access just being pissy? I thought I've made numerous queries like this, but now it's giving me the error message of "Query input must contain at least one table or query." What is wrong with it? I am basically trying to append data from text boxes of a form to a table. I have stored all...

This is one I found . Has anyone installed this tool? I'm a bit hesitant.