Recent content by gebuh

I get a warning- "expression typed incorrectly or it is too complex to be evaluated" I found a work around- it ain't pretty but it works, I just don't understand why using dateValue wouldn't work, I ended up doing this: get year, month and day from lastEditDate Mid([lastEditDate],7,4) &...

no it doesn't - I get the same results, I've looked thru all the records- they're all in date/time format

Hi all- I'm creating an update query. I have a field [dateLastEdit] that is stored as text, I have to compare it to a date entered on a form by user [date_from] (I need to select all dates greater than this) but I'm running into problems: when I use date_from in text or date format and compare...

thank you, I ended up just making a separate delete query- but this modification worked.

Happy new year all. I have 2 tables I have a query that if any tbl2.num=tbl1.num AND tbl2.action = 'confirmed' this row should be selected for deletion from tbl1. I've tried linking the tables and using an iif statement, but no good and I'm not sure what else to do- any ideas? Forgot to add-...

I figured it out- whether you want to or not, you learn something new everyday. I had a default value set in the table- it was defaulted to the last day of the month, when I got rid of this the query worked.

dim'ing the query as a string is good coding practice- but doesn't affect it working. I also created an access query from scratch and ran it with the same result- when I selected SQL view of the query it was: UPDATE tableMetrics SET tableMetrics.endCurrMonth =...

I have a table with one entry- just a date that holds the last day of the month for a function that reminds the user to do something. I have some code that's supposed to change this entry via an update query- but it's not working- literally, no errors, just nothing. I tried running it in an...

Hi all-can anyone tell me what I'm doing wrong here? I'm trying to copy the page, row and column fields in an existing excel pivotTable from access using automation- I'm trying to automate a report from a pivotTable. No matter how I do it I keep getting errors while trying to start the excel...

I think I have a solution to the commandBars problem- this module captures the users toolbars, turns them off, turns on my custom toolbars and when my application closes resets the toolbars to their original settings. Any comments welcome Option Compare Database 'array to hold users current...

thanx for the info, I was doing that, but I was experimenting with trying to find a way to return the user's settings to what they were before they used my db. Guess I'll have to keep looking.

the debug... I put in for troubleshooting. the showToolbar, to turn toolbars on. enable/disable will actually remove the toolbars from the db- but it also changes any other db the user enters. If I just enable the commandbars, it won't return the toolbars to anything close to a standard...

could be- but then '0' commandbar would just not be enabled, this code is causing an error that shuts down the db.

Hi all, can anyone tell me what I'm doing wrong? I'm testing the code below that's supposed to enable all commandbars and make them visible if appropriate- but it is causing access to shutdown whenever I run it. If I can get it to work I want to be able to reset a users toolbars after my app...

Hi all, I'm using access 2002. 2002 has pivoting, but in order to use it you have to download an xp add on(at least I did). After I installed the libraries pivots worked for me- and I added all manner of niftyness-before I discovered that no one else in my department could use it without...