Search results

Hey there again guys, Everything has been going great on my project (especially with you guys helping out with my mishaps!) up until the dreaded topic of reports has surfaced! The system is a basic CRM system for a friend and I need to generate a basic(ish) report. The structure is as...

thanks for some more input high tech. I need two forms as there are quite a few fields to fill out for a business. The initial Add has only the basic necessities and the edit form has alot of optional extras. My friend who I am making this for has also requested it this way but was aware I can...

Hi there Hitech, thanks for the speedy reply. I think you might be right, there are going to be more than a few address records. What do you think the best way to use a subform would be? Pretty much I just had a play around after your reply and wrote a query to select the fields I want from...

Hey there guys, just having a little bit of trouble with my forms and I'm sure there isn't a big problem and was hoping one of the guru's on here would be able to lend me a hand. I have two forms, one to add a new business into the system and another which finds and edits businesses already in...

Hey there guys, I used a less than desriable solution but it works, kind of stemming on from gemma the husky's result. I had a flag set to one, very similar to the open args method and whilst the flag was set to 1 all the from controls edit functions were set to false. This also set my search...

Well the form usually isnt read only and is fully functional but I want to be able to open the same form from a different menu and have it read only. The code I am using so far is: [Forms]![frmViewOpportunity].Form.AllowEdits = False This works, however there is a text box on my form where I...

Hey there guys, I have been trying to get this working but havent managed to figure out how to do it using VBA! I have a button which opens the form so you can view it but not be able to change anything. Any Ideas on how to change the form controls using VBA?

Hey there Bob, That was exactly what I was looking for. However, I don't quite understand how this query works? What is MsysObjects doing? Is that just looking at all the tables, forms, queries and reports being system objects and the ".Name" looking at what their names are? SELECT...

Hey there guys, I have been looking all through the internet and on the forums and have not been able to find a good solution for launching reports from a form. I was wondering if anyone had any guidance on what to do? So far I have a Listbox Where I have typed in the names of the reports...

Haha don't worry about it mate, you put me 100% on the right track and I fixed it up. Cheers, Andrew

Hey there, thanks for your help. I can't seem to find the allow updates property but I have found the allow edits, allow additions etc and that works a treat. I assume that is what you mean! Thanks once again namliam! Andrew

Hey there all, I know there is an Add and an Edit mode in which you can open and view forms but what I really need is a form which can be opened and viewed where absolutely none of the fields can be touched or edited. I don't really want to write code based on a condition which will then go...

Hey there Smartcard, I had a very similar problem to the one you are facing now and found that there was no easy way to do this. What I ended up having to do was use a textbox and bind it to the combobox which was set to invisible! Less than ideal I know but it seems there was no other easier...

Ok thanks alot guys it works! I had not included the square brackets as I thought the use of speech marks would do the same job! With regards to the table names, I did not create the database! All of the forms I have made however do follow appropriate naming conventions ;) It still amazes me...

Hey there, having a bit of trouble with the Dlookup function and was wondering if any of the guru's out there could help?? The code which I am using is: Private Sub Opportunity_Id_AfterUpdate() Dim OpportunityID As Integer OpportunityID = [Forms]![frmActivity Add New]![Opportunity ID].Text...

Hey guys, Great to hear what you think! I'm currently studying and I usually work with SQL Server and C# programming. I have however been asked to make a database for someone just as a project and they do want it in access. It has about 9 tables and some of the tables will potentially have up...

Hey there everyone, This is just for curiosities sake, what would define a large access database (how many records, tables etc)? Cheers, Andrew

Haha i get what you mean. I'm not a frequent user of access, but cheers for your help! I would probably still be looking through the property box!

so you reckon that I have both a combo and a text box? the combo box can be invisible and just be passing values to the text box? I have done similar things in my DB already but was just wondering is it an acceptable programming practice?

Hey there Bob, Haha I shouldn't have spent so much time looking then! On my Activities form the user can add a Company from the company table to the Activities form. There are going to be quite a few companies to choose from so I have included a button next to the Company ID Combo box to let...