Search results

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

Insane_ai - You led me to the correct answer! Thanks so much!!! It turns out that my Authors query that was providing the data for the combo box had 2 columns (I designed it from the wizard) and the column providing data was the column that only had "Last Name" Yes, the Authors form has an...

No worries, it was a good thing to check. Yes, I'm also wondering if the comma is the culprit, but I've designed many other things around that field... Modifying it to parse separate Last and First Name fields together will be pushing my limited VBA abilities. I haven't been able to figure...

Hi Insane_ai - Each author does have a unique ID, but in this case, I'm not referencing the author table directly, I'm just trying to match up a field of text to another field of text. The query for the report doesn't reference the author ID, only the "Last Name, First Name" Field which is a...

Hi Isskint - I checked my code and I have the correct number of commas according to the help dialog that comes up shows that it is actually in the WhereCondition. The Combo Box is populated from a query that accesses the "Authors" Table and just sorts the single field "Last, First"...

Hi, I'm currently in the midst of my first foray into the access world. I'm making big strides, but also trying to extensively customize the project... What I have right now is a command bar that has buttons that open up an variety of forms and reports. The data I am dealing with are reports...