Search results

I use access 2003 Database with a switchboard front end. What I want to know if I can do is when I open a report, if it is possible to code in a way for the user to highlight a field or cell, and to choose to change the text to a different color. Is this possible? Can anyone point me in the...

OK Bro, I will have to learn a little more before I am at that level I suppose hehe.

Hey Bob, one more quick question. I am using this DB that I did most the basic work on, but as I said my interface is using a switchboard with a form for it. I have taken several VB classes in school so far, and know how to do enough to actually build a better form with VB, but the thing I dont...

OUTSTANDING! Thanks for all the info and suffering an ignorant coder :).

Awesome! That is what was wrong.... now I have an additional question or two. It works, but it shows the time in the 24 hour clock (Ex. 23:34:34) and updates every second. Like you said, using system resources every second. I know how to fix the update every second part... by changing the...

Followed your directions, but when it opened the VBA window, it wasnt an on event sub, at least it did not look like one to me... the Sub (with my code added is below. Private Sub Form_Timer() Me.Text70 = Format(Now, "hh:nn:ss") End Sub It gave me a different error this time. Run-Tim...

Getting an error: "The expression on timer you entered as the event property setting produced the following error: The object doesn't contain the Automation object 'Me'." I trie dit with the code builder and expression builder. I double checked the name of my textbox also.

Thanks Bob! I agree its not important, but the boss (wife) wants what the boss wants :).

I have the time function on it, so when you first load the switchboard it shows the time it was loaded. Is there some way that I could have it update each minute or to reload so to speak? When I say clock, I mean a digital reading of the time, not a graphic clock.

Sorry for the vague subject, but I really could not think of a way to sum this problem up. OK, I have a database with a field titled Meal. In this field there are 9 possible choices: REG, N/P, N/M, C/F, BAG, Styrofoam, REL N/P, REL N/M, REL C/F. Now, I have a report that lists how many of each...

Awesome! That was SO much easier than what I was trying to cook up, and it works perfectly! Thank You Neil!

I have a query in my database, and I have recently added new possible entries for area. My report tells me how many male chickens vs. how many female chickens I have. Now with the new entries for area, I want my breakdown to EXCLUDE any chickens that live in a specific area. For instance: Pen...

Sorry bro, I had posted that before I read your last post. It worked perfectly once I placed it into the report footer. Sorry for the confusion, and again many thanks!

Awesome! It worked! THANKS AGAIN BRO!

Still errors out with: =Count([Meal]) I attached the DB minus just about everything except the table/query/report that I am doing, so you can look at it. The report is named: SHU Cell Assignment (A-Range) The control I want to do is the only one in the footer, you can't miss it! PS: Just...

OH Yeah, I used Office XP Developer to make it!

OK Bro, In order to attach it as a file, I had to delete almost all of my queries, reports, extra tables and all data except for a single range, which is for the report you are workign on. That means it most likely will not run at all, but you will be able to see the table structure, my query...

Man Roy, I tried to use the exact same syntax on another report, and again I get errored out. This one is even simpler than the first. It is a report of a query, a select query, that lists all cells and who is in them. At the bottom I wanted a total of how many inmates are on the range, so I...

Hey Roy, I got it to work like I said, but one aspect of it really surprised me. As I said earlier, one part of my report was to show how many inmates are housed in SHU, which would take any inmate with a cell number starting with A, B, C or D. When I first got it to work and changed the...

It may be easier to create a single query on both tables, then to create your report on the query, that way you wouldn't need a subreport or subform, you would have all the data you need in your query.