Search results

Solution Problem's fixed. If anyone out there is looking for the answer to a similar problem - DoCmd.RunCommand acCmdSaveRecord DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdRecordsGoToNew DoCmd.RunCommand acCmdSelectRecord...

I have an idea, but not sure of the code... From the 'new request form' the date is then entered in a seperate form for the 'add a date'. Now, if I can have coding in the on open event of the 'add a date' form that basically says - if refering form was 'new request form' then copy and paste...

Hi all, I have another problem on my vacation request forms. Everything is working perfectly except on the the new request form. When I click on the 'add a date' button, the code is supposed to save the record, then copy and paste it, so I should end up with two copies in the database. No...

Oh... here's a copy of the final coding, if anyone is having a problem along similar lines: If Me.Dirty Then DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70...

Got it. Finally! There were certain fields that I had locked and disabled. Apparently access didn't like this. I don't know which did it, the locking or not being enabled. Frankly, I DON'T CARE. It works. :) Hope me rambling to myself here helps someone! MJ

I also took the above code and replaced it with: DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdRecordsGoToNew DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdPaste In this attempt I received the message: Run-time error '2046'...

Hi all, I have a form for entering time off for work. Each day of vacation has its own record in a table because we need to track who's covering that shift, and it could be different each day. The form for entering requests has a button which is supposed to copy that record and create a new...

ok. it's working alright now, referencing a 'dummy' table. the only thing i can't seem to figure out is the format - Format(Now(), "mmm yyyy") is returning a charactor string (arranges the months alphabetically) Format(Now(), mmm yyyy) is telling me - syntax error, missing operator. i had...

next step, of course, was to write the dates into one query and then write the union query. it's giving me the same error now. this makes no sense as i AM referencing a query now. computers suck

i tried to run a union query and it's giving me the error - query input must contain at least one table or query.

after a lot of googling and trying to figure this one out on my own, i've come up with nothing. all i need is a combo box that starts with the current month and goes back one year. something like: May 2007 Apr 2007 Mar 2007 Feb 2007 Jan 2007 Dec 2006... i've tried a couple methods with no...

hi all. i need to set the parent form (MainMenu) to maximize on focus of child form field. anyone know the code to do that? thanks, mj

Solution! thank you bob, you sent me down the right track. the Nz still returned it as text, even without the quotes, but the other formula worked: IIf([AvailTab].[Per00] Is Null,1,[AvailTab].[Per00])AS Per00Test i also had to get rid of the format statement in the sql, and just formatted it...

hi all, here's the dealio... i need perform an aggregate funtion off of a certain field, but it contains null values. i tried using Nz and an Iif IS NULL statement to get rid of the nulls. but both methods return the values as text. obviously, i can't get an Avg of these text values...

solution found! for anyone who is facing the same problem, it is very easy - Format(Insert your subquery here), "Percent")AS NameOfSubQuery too easy. mj

ok... i've been through access 2000's useless help index twice now. i've also spent over three hours looking for a solution online. i'm all googled out. there has to be a solution somewhere. someone please help!!! mj

hi all, i normally just go into design view in my query to change the format type, but some of my subqueries are quite large, so i'm getting 'the expression exceeds the 1,024 character limit for the query design grid. i figured i could just multiply the subquery by 100, but the results are...

For anyone else searching for the answer to a similar problem, I just used the MIN and MAX function on the dates. Didn't even have to select the systems as 'DISTINCT' in the query. Thanks again for the help!

That makes perfect sense. Don't know why I didn't think of it. :D Thank you!

Here's a good one for the experts... I have a query that sums downtime on equipment. The problem that I came across is that there can be multiple status items open up on the same piece of equipment. When the restored time on one status item occurs after the down time of another, the query...