Search results

I am trying to copy a telephone number from a web page and paste it into my form. The text field on the form is the standard ten digit USA telephone input mask. !\(999") "000\-0000;0;_ But when I try to copy a telephone number, 212-555-1212 or (212)-555-1212 or 212.555.1212 only the first three...

This has been driving me crazy for the last hour. Should be simple but it just doesn’t want to do what I want it to do. Set the cursor at the beginning of the text box if the box is void of any data. I have tried the following but nothing seems to provide me with the required results. It is a...

I am trying to figure out why the first code seems to work and the second doesn’t. I am trying to create a folder on Dropbox using VBA so that I don’t need to know the user (or computer) name to do it. Dim myPath As String Dim myFolder As String myFolder = myPath & "AAAAA" myPath =...

At times when I try to import data from Excel I get the error message” “Microsoft unable to append all the data to the table” or something like that. I am trying to figure out what error code this is if any and how do I trap it so I can advise the user to contact me. I know that there are error...

Here is the "fix" from Microsoft. Has anyone done this yet? We have a local network, front ends on individual desktops, back end on server. Only one person our of four can be on the DB at one time right now. Error in Access when opening a database on a network file share (microsoft.com)

I've gone brain dead for the last hour trying to figure out how to parse out the street address from a string. Tried InStr, Left, etc., but keep getting into dark places. As an example, the address might be: 1 State Street, Anywhere, NY 1001 I know how to get the city state and zip just can't...

I have been trying to figure out a way to copy a telephone number that is usually in the format (800)-555-1212 into a form. The form is formatted for telephone numbers so the input mask is (???)-???-????. Right now when I copy the number to the telephone control it only pastes the area code...

I want to compare two large lists where the Organization name is the same. Unfortunately the names may not be exactly the same thus I am attempting to parse the first word in each list against the other. Thus I thought if I could get the first word in a string that I could at least determine if...

When all the computers at work were upgraded to Windows 10 and Office 365 and I still had my old machine with Office 2010 at home where I do my coding, I had to start using late binding because of some issues with Office 2010 programs; not all of the computers at work were changed over to the...

I have the following code to search for a record based on its record number. What I want to do is modify the code so that if a certain number is not found I want to open the next sequential record. I.e. if record number 80 is not found, then open the next record in sequence which may be 85. (I...

I tried to modify the code found on BaldyWeb that opens a record set and includes all the records. So far I have gotten to this but nothing happens. I definitely have records where the Organization name begins with B. If I could get this to work then I could use a letter picker to change the B...

My wife has been after me to get a new bridge for our Koi pond/stream and today I ordered one from Wayfair. About an hour later she told me that she found a bridge that would fit nicely and I should order it. It appeared as an unsolicited ad on her Face Book feed. It was the same exact bridge...

I have the following code that worked fine until I tried it today. I have not used it in a while, so I don't know how long this has been not working properly. msConfigURL = "http://schemas.microsoft.com/cdo/configuration" With fields 'Enable SSL Authentication .Item(msConfigURL &...

What am I doing wrong? This is my sql statement from the query: SELECT TOP 25 tblMain.ClientID, tblMain.FirstName, tblMain.Organization, tblMain.Email, tblMain.OnSendList FROM tblMain WHERE ((Not (tblMain.Email) Is Null)); And this is my SQL statement in my vba code: Dim sSql As String sSql =...

I want to select the top X in a query. I know how to do it using return X from the design tab or Select top X in the SQL statement, but is there any work around for setting a parameter in a form to do this. All the info I found so far says no, but perhaps someone has found some way to do this.

No locking file. Access 2019 When I open my DB, usually there are two locking files. One for the front end and one for the back end. Yesterday one of the users was having problems so I checked the DB and noticed that the small locking file for the back end was not there. I did a compact and...

I work remotely from the main office, mostly retired but helping out the Access Databases. For some time now the back end of the DB has been crashing with regularity. We finally narrowed it down to one computer terminal that seemed to be the culprit. For months I have been telling them to check...

There is a popup showing the compressing of a file when executing the standard Zipping File code that displays when the file is zipping. How do I suppress the pop-up? I believe it is in the following line of code: ' Wait for compression to complete before exiting Do While...

I have a query where one of the fields is [Date1]. In the query I have the following to sort [Day1] by the day of the week. That is, Sun first, Monday second, etc. DaySort: InStr(1,"SuMoTuWeThFrSa",Left([Day1],2)) Was using Access 2010 now using 2019 and this is giving me an error. Never had...

I wrote the following code for my Access 2010 program:and it worked like a charm. Dim DayVal As Long DayVal = Weekday(Date, 1) 'Set first Day of Week, in this case Sunday. If (DayVal = 6 And Hour(Now) > 15) Then Call cmdZipAndEmail_Click End And when I transferred it to Access 2019 I get the...