Search results

a lady was using it yesterday with no problems... i just designed this program and we are just testing it out now, today we are having issues. i honestly dont know what version SP we have and if any hotfixes are installed... I just started here as an Engineering Co-Op.

oh sorry, i'm using acess 07

another issue is that when i update an entry that doesnt exist yet (because the entry was skipped for whatever reason)... it wont add that entry even though all the steps are performed with no error.

Hey, I have a form that is used to update previous entries to the table... that way when RMA's are received or closed, that information can be added. For some reason when I type in the RMA number (which is my primary key) and hit "Look Up"... it looks up all the fields for the table and puts...

i saved the file as a normal access file, not the accde, and it runs fine. Something about the accde file doesnt agree with having 07 and 03 access installed.

no sorry, i tried that and it doesnt work :(

Goodmorning all, (depending on location) I have come across a problem with my .accde file. On our computers, we have both 03 and 07 Access installed. There are reasons that we need both. However, this being the case, users with both of these versions installed cannot open the .accde file on...

yeah i thought about that after haha. eventually i'll code in a button to just print the table off if need be. instead of locking the table, i chose to have an "update form" to manage the data with a "lookup" command based on the rma number to see the data. so i guess all that being said...

no i'm serious. i'm a creationist. i believe in God.

I have set up a button on one of my forms to "view RMA list"... this button is password protected but I want to add a feature that will disable the table from being able to be manually changed. Is that possible? Thanks, Rob

nevermind i solved it with one line of code... (mind you its a long line haha) DoCmd.RunSQL "UPDATE RMA Set Customer=[Forms]![UpdateRMAList]![CustomerNameu], Location=[Forms]![UpdateRMAList]![Locationu],DateIssued=[Forms]![UpdateRMAList]![DIu], DateReceived=[Forms]![UpdateRMAList]![DRu]...

perhaps if i first coded the removal of the entry, then used this to re-enter it... that would work... any suggestions for this or another method?

Ok so I was thinking last night about the database I have created, and I came to the conclusion that I need another form for updating existing entries. The RMA gets entered into the system but needs to be updated when we actually receive the parts and also when the case is closed. Therefore I...

sorry, coming into this discussion late.... I believe in the Big Bang... God said it... and BANG it happened :)

I got it working at the end of yesterday! I finally had enough with the "insert chart" and created another form to display in "PivotChart" mode. It's working quite nicely now. I came up with a couple more forms I need last night, like an "update RMA list" form that can alter the previously...

here are two screen shots of my data... the first being a shot displaying the query made from the "report selection" form with the graph in the background... the second is of the query builders for the query made from the form and also the query for the report hope this helps diagnose. Rob

i'm not sure how i can simplify my query any more than it already is. the query is built from my "report selection" form, which allows the user to pick the date range and location for the RMA report. the query then selects the data from the master table that fits the criteria from the report...

Thanks for the reply Ken, now my query from which the graph is displayed is a simplified version of my table which contains all my information. the query is just the data i want in the graph. it contains location (for the series), total RMA (for the y), and Date (for the x). When i use the...

no one? any help would be greatly appreciated

bound or unbound form?