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...

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...

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...

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...

Howdy I need to save a user's machine name when they comment on a record. I have a form that has a comments field, and a separate area that shows the historical entries from comments. I also have an invisible field populated by "=fOSMachineName()" that shows the users machine name. Getting...

I have a table with a field called "Close Reason" that starts out blank. I have a second field called "Date Closed" which also starts out blank This field is used on a form called "Opportunity Details" via combo box. (The form is based of a querry that calls the table up) When someone...

Hi I need advice. Just a sense of direction really. Should I use a calculated field on a table, or a seperate query? I need to perform calculations and show the results in a form. I have a table called recipies that lets users select ingredients from several different tables, and then a...

I am struggiling to format a field on a report. I believe it is because special charachters are in the text string I want to highlight the field if it contains the following text Stage 6: Won and Deploy (shipping) Regretably, I believe Access see this as code. I suspect I need to...

I need help with a general concept. I am more of an Excel guy, so I probably don't know the correct terms for Access:cool: I want to be able to click on the data that someone else has entered into a form for more details. The form is a detail form for forecasting opportunities, and one field...

I have a table called opportunities. I can update data and add data to the table by using the Collect info option in Access 2007. All has been working well. My issue is, once an opportunity is closed (by a checkbox in the form) I no longer want to send it out for updates. I can not delete...