Search results

One other thing, my button labels 'On click' event does call a procedure called =MMouseClick(4). Could it be this? Has there been changes to the way procedures are called from 'on click' events in 2007? I do have a procedure Private Function MMouseClick(index As Integer) and i have put a break...

Thanks for the reply Ken! As always the answer isn't straight forward , so i'll try and keep this short. There are five buttons that update depending on what is pressed. 2 of the buttons just link straight to opening up a form (making it visible) the other buttons refresh the button label(s)...

Hi, Our company is currently moving to some new servers and unfortunately I’m being forced to move to access 2007 :( So, i have a problem trying to run the database i had created in 2000/2003. I have a button the i use to open a form, when i click this button i get the following message. "The...

Thanks for the reply Vassago, yes this is a reporting services project, and unfortunately the only problem i have is when having to connect to an access backend... Anyway, If i try getdate() i get the error 'Cannot convert to valid date/time; TO_DATE function might be required'. If i try the...

Hi, i hope someone can help. I've be trying to create a simple report using 'report server project' in Visual Studio. The report I'm trying to create gets its data from an Access database. All I'm trying to do is get some data with the following date range: QuotCompleteDate = Between Date()...

Thank you all for your responses! I think I finally get querydef. I’ve always strugged to get my head around it! I made the changes you suggested Galaxiom and it worked instantly! Thanks again! This forum has come to me rescue yet again! :D

Hi, I'm having a problem with querydef! I have looked at tried all sorts of different solutions and now i need your help. I'm trying to export a query into excel, and this query has a parameter that looks at 2 date fields on a form. Between Forms!frmSwictboard!frmDatabaseReports!txtStartDate...

All sorted, thanks namliam. Sometimes you can't see the wood for the trees...

Ok, i'm going to go the recordset route. I have used them before successfully, it was a while a go though. Just one thing, can i base the recordset on a query that has a parameter on it? I need to match a record with the current form ID? Dim myDB As DAO.Database Dim myRS As...

Thanks for the tip about CDate, i'd never heard of that until now. Alas that hasn't solved my problem. I've even made sure i have valid records in the table so that don't have to rely on catching a null. I guess there's a difference but I'm not getting a "data type mismatch" just a "type...

I'm sure I’m being very dense can someone point out my obvious error? I'm trying to do a dlookup for a date in a table where the form ID matches the ID in the same table. Dim dteTimeLower As Date Dim dteTimeUpper As Date Dim intCurrentID As Integer intCurrentID =...

searching isn't working for me....or posting by the looks of it :-(

searching isn't working for me

I'm going to bump this just once. I didn't think i was aking for something that complicated?

I'm back, and i'm still struggling! I've now based my mainform on a query. And i thought i would just change the recordsource of the mainform based on a new recordsource depending on which the button the user clicks. Now my next problem is that the recordset is not updateable. I've read a few...

Thanks for the reply ajetrumpet. The recordsource of the form is a table, i know i should really base forms on queries, for some reason i didn't in this case. I've attached a screenshot, i think a picture will explain better than my words. The results of the query that make up the numbers...

Hi, i need some help with filtering a form. I've read many posts on the subject, and for some reason (mainly my lack of understanding :o) i'm having a problem finding a suitable solution. If someone could help me understand the best way/method of achieving my aim then i would be very grateful...

I could be way off the mark here, but i've been caught out with the 'Too few parameters problem'. Try setting these too: Dim db As DAO.Database Dim rs As DAO.Recordset Dim QDF As DAO.QueryDef

Why is it when you struggle for a solution for ages, then soon as you ask for help you find it yourself? Anyway, i replaced DoCmd.RunCommand acCmdSaveRecord with Me.Form.Recalc. i guess its not the 'correct' way of doing things, but it works!

Hi Access Experts! I try not to post questions on here, most of the time i can find out the answers for myself, unfortunetly i'm completely stuck with this problem. I'm getting the following error 'The command or action 'SaveRecord' isn't available now. I've got quite a large fairly complex...