Search results

Wow! Long time, no see! I played a lot with Access 2003 about 4 years ago, but stopped and work no longer required it. I'm now presented with a very, very simple database (1 table with a form view) that I want to make better (remove the option for human error). Issue: I don't understand the...

Has anyone noticed that quotation marks (" ") transferred from MS Word are not recognized as quotation marks in Access? I will sometimes use the text-coloring effects of MS word to sort out, visually, some functions in some of my more complicated expressions if I mess up the parenthesis or...

Hey guys, Is there a function that would let me know if a field value is purely numeric (no symbols, no letters, no spaces)? I'm thinking of using in an if/then statement like: iif([field] isNumeric, "Jump Around", "Ice Ice Baby")

Hey all, again, Situation: "Table1" <-- Data Entry storage Record 1: FieldA, other stuff, other stuff, FieldB, more stuff, more stuff Record 2: FieldD, yadda, yadda, FieldA, etc, etc "Table2" <-- Field Data Source Record 1: FieldA, Adata1, Adata2 Record 2: FieldB, Bdata1, Bdata2 Record 3...

Hey all, How do I go about changing the query a report references for data? I know I've done it before, on accident, but can't seem to figure it out now. Thanks in advance.

Hey all, Need some help here. I need a single-button/click export of a query to excel. I can't seem to find any built in function to do it and I really don't know VBA/SQL to make the function on my own (go go Access GUI survival!). I know how to slap a button on a form and I've played with...

Hey all, Using the built-in query builder, how can I filter the query by a user defined range of record IDs? I know about the "like" command in the criteria field, but I don't know how to implement a range of criteria (IDs 27-54).

Hi again, I'm having a bit of trouble with these two concepts and am hoping someone could shed some light how I could use one or the other to get what I need: Have I have: FieldA, FieldB, FieldC, FieldD I need to count up all the fields that have "X" as a value in all those fields combined...

Simple question: How does one reference a checkbox status in an expression? I have a bunch of checkboxes [FC1YN] through [FC4YN] and need to know how to reference them in an if/then statement. I thought "yes" and "no" values would be appropriate being that they are "yes/no" fields, but I only...

Hey all! I've received yet another feature request for my main DB. A while back, I was trying to make a search form to filter the records in my main form. A kind fellow suggested I use the right-click menu and tell others to use the filter option in there. It's worked, but people would still...

Hello again my forum o' saviours, Current filter: AcademicYear is a field in the Assignments table (duh). In this same query, I have a couple fields (equations and if/thens built on the assignments table) that will need to be used as further filters. I thought something like would...

Hello again, A while back, I asked about the now-removed function of exporting Reports to Excel. I was told that there's no way to do so in Access 2007 and that the best best would be to export the underlying Query. I did so and I found out that the query was showing the record number of...

Alright, so my pride and joy and departmental savior database has been fully implemented and people are so pleased with it that they *all* want to use it at the same time. Initially, I made it custom for three peoples' UI preferences, but since it's such an intuitive design, other staff now feel...

Situation My database stores course information for faculty in my department and prints out various reports based on that information. The 2 mandatory fields in the form are [AcademicYear] and [Instructor] as they create the potential for classes to be added to the curriculum. Question Is...

Here's one for you guys: My vision-impaired staff are having trouble seeing the blinking caret when they tab over to the next field in a form. Is there a way to highlight the newly-selected field instead of just having a thin blinking caret to guide the way?

I've run into a bug, I think. I have a time field with it set to show "Medium Time" which is "hh:mm(AM/PM)", however, when I combine the information with another field in a query (=[OfficeDay]&" - "&[POfficeTime]), the time comes out as "Long Time" or "hh:mm:ss(AM/PM)". End result is Wednesday...

[NOTE: I'm no programmer] Hey, long time no see. The info I've received from these boards have been able to last me a few months but now I have another request from my users. I made a database a while back that stores all the courses my department's faculty teaches, when they teach them, if...

Hello again, I've run into a bit of a snag: I use Access 2003 to make/fix databases. The users use 2007. In 2003, I can export a report to Excel by right-clicking on the report, clicking on export, choosing Excel spreadsheet as the filetype, and saving the file. This is not so in 2007. In...

Oh, the trials of working with people who believe word documents are sufficient ways of storing data! Background: The people with whom I work did a mail merge a long time ago and have been updating the resulting 80-page documents manually when they receive a change of address or when they need...

Hey all, I have had yet another feature request for one of my databases. It seems as though the built in search box at the bottom of the Access window is much too small for some people to see/use efficiently. They would like a nice little pop-up form or search field embedded in the form...