Search results

I have a contract compliance issue that should be simple, but is confusing me. I have two tables. One is about 160 thousand records, which is a part number, a contract price and a day the price took effect. The items appear several times. Prices go up and down over the course of the data, and...

I have that much down My problem is it copies ALL the records from the master to the history, and not just the specific record on the form. I suspect I need to pass a variable from the form to the query

Good Morning I need a simple audit capability I have a table (Called Master Active List) I have an empty duplicate of it called History of Master Active List. (Identical fields, with the addition of a distinct ID (primary key) I have a form where the master can be changed (Called...

Dude! This ROCKS!! Books being ordered!! This is a powerful tool being built here. With this template available MANY awesome things are possible Profound thanks. I have tons of more questions, but I shall save them for future postings, so you can help others!!!

http://postimg.org/image/9s4s8wckz Image One

Referencing For Each Record or Lookup Record?

I have errors saying "Unable to resolve the reference to Quote Requests (My main table) Name="SetLocalVar"><Argument Name="Name">varRecordID</Argument><ExpressionArgument Name="Value"><Expression><Original>

I have bombed out :( I think I am close

Done and standing bye! I did not create an old / new for the index or the "Date Created" field in the table? Should I? Otherwise I am ready to role!

l ultimately need to record all changes in a table called Quote Requests so I suspect I need it at table level, but I am clueless, so feel free to guide me like a blind man! I wish to simply insert the whole record into another table every time it is changed (meaning any field within the...

No I have not! Can you point a poor befuddled old school guy in a direction other than the circles I seem to be running? I am liking the stuff but PLEASE get some documentation! I already bought a few books, and frankly nothing on Web Apps. Perhaps some sample code to toy with?

I am new to Web Apps (Interesting, but frustrating!) I need to capture when a record is changed I have an area called Sales Persons Notes (Sales_Person_NotesTextBox) When that is changed I want to update a field (SP_Notes_UpdatedTextBox) to reflect Now() For some reason, I can't...

I have just begun playing with Web Apps. All is well with one issue bugging me to no end I have a view (Based on a query involving two tables) that will not permit updates All looks good, but my Edit option is grayed out. Documentation is horrible. Can anyone suggest where I...

I am aware how to use Access to forward reports and similar via Outlook. What I am unsure of is can an attachment connected to a specific record be forwarded via macro? I have a form where a user sees all the details of a specific record, and a user who must save the attachment from the...

The data is displayed in the form via a text box. I just want to reverse the order in one particular box. Can that be done on the form setup? It seems intuitive it should be possible, which usually means it isn't. I can parse the data, but reversing it would seem elegant! Any clues?

Howdy all I have after much stress gotten my comments history field to appear on a form. The following code gives me what I needed =ColumnHistory([RecordSource],"LastUpdateBy","[ID]=" & Nz([ID],0)) I have only one simple thing left, that is perplexing to say the least. Some comment...

Where ya been all my life? Normally if I even MENTION this stuff to a woman they run away get that glassy eyed look. Double the Kudos for you, we need more like you

Look at me! I got it beat, Thank you both! Nothing further needed, just curious why you have a last date changed field, when the last user field would have a date and time stamp? In any event BRAVO gentleman, you both have a slot waiting in my Zombie Apocalypse bunker. :D

Way cool! Having only a 7th grade education and ending up a programmer I am ALWAYS amazed when I learn something new!! One last issue before I order you a gold plated pocket protector. I have what I need, but now I have TWO save and close buttons. (I know, seems silly right!) The...