Search results

I have a section of a database that keeps track of gas purchases (see attached photos), called tblGasoline. I have constructed a subquery that will calculate the "previous" ODO read so I can tally the total miles driven since the last fill up. I am looking to create an additional field that...

A particularly odd little scenario, and I am almost certain this is a bug. I have a form, [Financial Information] that contains a subform [chtWeeklySpending] which is displayed as a pivot chart, among other subforms. Whenever I make any changes to VBA code in the [Financial Information] form...

Thanks for the input. One of the most common things I've seen on forums is the questions which asks for a very specific answer to a frighteningly vague problem. This approach uses more of the high school science class lab report style which we've all been exposed to, so it shouldn't be...

I just read the thread suggesting how to ask questions the right way, and now I'm paranoid that the method I used is more trouble than it is helpful, so I want to run it by the forums Generally, when a problem comes my way, I tend to search the web for a quick answer, then use MS Help (sadly...

Thanks, I think I'll just have to bring my laptop to work in order to work on it. Not too excited about that, but there seems to be no other way around it. Thanks for the suggestions, everyone.

Thanks a lot for the suggestion. I've had several problems with this, programming it sometimes on my comptuer at home (Access 2007) and sometimes on the one at work (2002), so it's done a whole lot of "...has encountered an error and needs to close...", so I have a lot of backups, thankfully...

I have been working on a personal finance database, and suddenly, I notice that both my tables and queries are invisible. All of them. I know they are still there because the forms that use both tables and queries are working and generating all of the data. I also know that they exist...

Hey there, guys, thanks again for all your help. I think to do what you all were suggesting required that I have a more advanced knowledge of Access, coding, and probably things my brain cannot comprehend at this point to understand your suggestions. I did come up with a general function in a...

ByteMizer, It sounds good, if it works and it includes Korean currency formats as well. Where would I find out about that? And where would I implement that code anyway? I claim no knowledge of VBA for Access, and I'm kind of new to Access anyway. I might need another push, but I will give it...

I really don't think this is working as I thought. First, some clarification: Paul, your multiple Currency options seemed too good to be true, and that's what it was. However, in all honesty, I'm not sure that's the approach I want to take. It's rather inelegant (no offense, but any NEW...

Thanks guys. pbaldy, your suggestion sounds as concise as any. The only real issue is that I'd end up having to do that for each query. I'd love to make that a standing condition that gets naturally implemented in the entire database. As for the ([My Field],"Currency") suggestion, that...

Background I have a personal financial database that keep track of my accounts in three different countries, the US, Korea, and Australia. Goal I want to be able to display a report (or subreport, rather) of my accounts for each currency. Problem Korean won (KRW) do not use the "#,##0.00"...

This was a surprisingly easy solution. I just swam around in Access and figured it out after some time. It involves (1) establishing the criteria on the chart's Row Source and (2) creating a macro for the event On Click. 1) Go to the chart's properties, under Data / Row Source, and enter the...

I'm sure this is not in any way an overly advanced procedure, but this is the situation. My Access skills are by no means advanced, but I do know a bit of VBA and have a cursory knowledge of SQL (I can read and understand it, but I could not write it from scratch -- so jealous of you kids who...