Recent content by pswilliams0

Khalid, lets not jump ahead now. Nobody deleted a record, rather a SINGLE record became corrupted which caused issues with the indexing of the Jet database. Once the backend was repaired, everything worked like a charm. Prior to this, any attempt to delete the corrupted record was not possible...

Ok, I found the issue! A single entry had become corrupted - or at least that's what I think - it read '#Deleted' in all fields. Because of that, the indexing of the searchable fields was screwed up and just returned errors upon querying. Upon compacting and repairing the backend table...

As I stated in previous posts, there have been no code changes. (Or any known changes to anything but data) The data isn't corrupted if it is all still there and can be searched via a different field on the form, right? However, when searching, only the autonumber will result in the desired...

Hi Bob, Thanks for your help. So, I don't know how to set the break point. I understand how it works, I just don't know how to do it. However, I know how to set msgbox functions. So, I did the following: stLinkCriteria = "[EN Number] ='" & Me.Text41.Value & "'" MsgBox...

As stated, no changes to the backend have been made for months. I am the only person with access to do so. also, I checked the field names to make sure and they are correct.... :)

Hi All, I'm a bit of a novice with Access, however this forum has typically had an answer when I'm completely befuddled... So, here's a description of my DB: I have a database that has a form used as a command bar. On that command bar is a text box. The value of that text box is used as...

The calculated dates don't check the weekend without it. This is my first experience coding, so I can't tell you why. I tried it without the "IsWeekday" function and the code sped up significantly, but the dates calculated were wrong. (i.e. the weekends were not excluded...) If you have an...

I have tried to look up how to do this and have had a significant amount of difficulty. Can you describe how I assign the data in the holiday table to an array and then reference the array in the loop? I'm confused how I structure that. So, I gave this a try but it didn't like the "between"...

Hi all, I'm new to VBA and was recently tasked with a small internal project for my employer. I created a form that automatically calculates a number of dates from a date entered by the user. The tricky thing, is that the dates calculated are workdays only. This means, weekends and...

Hi Pat, That sounds great. When you say I need to include them in the VBA event, what am I actually including? Could you possibly have an example to provide? In a perfect world, the dates would always be DDMMMYYYY -- However this isn't an option in access from the list of date formats...

Hi, thanks for the thought! Yes, that might work, however, I have VBA calculating future dates from the date entered. So if I left the format blank, Access would likely not know that it was a date to calculate the other dates. Philip

Hi all, I have an input mask in a form field for recording a date. I currently have it set to: 00\->L<LL"-20"00;0;_ This records the format in the "medium date" format of DD-MMM-YY or 15-May-12. The input mask shows the "20" of 2012 as you enter the characters for the first time, but...

I suppose I could be a bit more clear. I have a taskbar with buttons to operate the various forms. I am trying to find a way to have that taskbar show up in the bottom right corner of the screen, regardless of the resolution. Can this be done in VBA? Thanks

Hi all, I'm developing a complex database of forms and queries that things that I want to display at the same time. Unfortunately, the screen size and resolution that the access database is displayed on changes. I am familiar with the DoCmd.Movesize argument - but is there a way to...

Hi, I'm trying to accomplish the same task. Where do you put the OR statement? In the Query design view or is it VBA? Thanks in advance