Search results

That was it!! Thank you so much. And Vlad, thanks for the local settings suggestion - something I should have done from the start.

I put the code in an onclick event for a new button but am getting a compile error, Expected end of statement. Any idea what I'm doing wrong? With CurrentDb .Execute "UPDATE tblAttachments SET tblAttachments.AttachmentFilePath =...

You mean I would have to save all of the updates queries separately (ie Query1, Query2, Query3, Query4...). Then create a button somewhere and on click event something like this CurrentDb.Execute "Query1" CurrentDb.Execute "Query2" Please tell me there is another way of doing this...

Well I found a clever way of doing this with an update query and using "Replace". Seems to work, but now am trying to run several of these queries in one statement. Can't find a way to do it. These work on their own update queries UPDATE tblAttachments SET tblAttachments.AttachmentFilePath...

Hello, I have a split database and am preparing to relocate the backend to a different computer. Problem is that there is a lot of data in fields that are used as link fields that point to a specific location where the backend used to be. For instance, there are data fields that will have...

I looked into that thread, but it seems to be more geared toward Windows and not specifically to Access. And way too much work to adapt it for my purpose. I've got my app working now by changing the on focus event to on activate and deactivate events. Seems to do what I want it do about 95%...

Thanks MajP. I used your code and it does seem to work. But as you said, probably too much buck for the bang. Especially since this was just a small sample of what I'm trying to do in my database which has a lot more buttons with a lot more forms and users can enter into some of the top forms...

There is no way to know which form was just below the form the user closed. Need to find a way to know which is the TOP MOST form being displayed to set focus on that form.

I am trying to have a "Ribbon" type switchboard form (frm0) that will stay open all the time until the user closes the database. This form has buttons (Actually Labels acting as buttons) to open other forms. I'm trying to get the buttons on the switchboard to change color to match the form...

IsDST is used to set DST for countries in Northern Hemisphere, and IsDST2 is used to set DST in Southern Hemisphere. The problem I'm having right now is trying to loop a calculated event through the continuous form. I can create a "GotFocus" event on the DSTEND field so that the DST can be...

I think I may have figured it out. As you pointed out, it depends on the range. I modified the code to for the 2nd range. Now I just have to figure out how to fire the AfterUpdate event from a command button on the form so that I don't have to manually select each record individually in order...

I've changed them to date fields, but it didn't make a difference. The problem is the calculation needs to go the other way for countries in the Southern Hemisphere. But Can't figure out how to do it...

I am having a little difficulty getting my DST form to work for countries in the Southern Hemisphere. The complete thread originated here: https://access-programmers.co.uk/forums/showthread.php?t=215603 I've attached a sample database that shows the issue. Basically, enter the Start and End...

WOW - this actually works!! Fantastic. Thank you so much. It's exactly what I was looking for. For Mark - the reason I didn't want to see the seconds is only for the screen space and aesthetics. I need to make the box a little wider to accommodate for the seconds when editing the field...

OK - so are you saying that there is no way, or even a workaround, to get the time field to not show the seconds when editing?

I have a continuous form which has a current time stamp when creating a new record by setting the default value of a textbox field to Time(). The field is a Medium Time field and displays properly when the record is created. But if the user clicks the field to edit it, the Medium Time changes...

Hi June, I put the sample database using a form/subform which is the way my database was set up and having the problem. So you can't use "frmNotesSumnary" because it's missing the contactid field and would only produce an empty record when you come back from the single form. In order to get...

I forgot to mention in the instructions in the first note that to get the error, you have to double click the long record you want to edit. I've added the lines in your post above. Created new record of approx 2700 characters Moved to a different record to save it. *** Double click the...

I'm not sure what this means. How can I tell which way I'm using to update the field. Basically, I have a form with a note field. I can update the field directly in that form and will never have a problem. But I want to give the user more space, so I double click the note field and use this...

I have a split 2010 database that am having a problem updating a memo field when there is more than 2032 characters in the field. If I try to edit the field, I get an error message, "Could not update; currently locked by another session on this machine." The probem I am having is explained...