Search results

works I went back to my else statement as you pointed out thats where my problem is and replaced it with: Else stDocName = "frm_pocs_review" stLinkCriteria = "[Company]=" & "'" & Me![Company] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.Close acForm...

Consider yourself provoked John471 - Thanks for replying. I'll look into bookmarks, I'm not familiar with them. I'd be happy and open to hearing your more complicated approach if you think it'll work (and I can actually implement it!). or anyone elses ideas are more than welcome as well...

I'm discovering VB is so not my thing and I'd be lost without you all! Having said that, Please Help! I had previously had a problem of opening a record where a record didn't exist on the same form - my code was sited as interesting code by one poster ;-) however it does work. Well now I'm...

got it Thanks for the input. I actually got it to work using the following: Private Sub Company_AfterUpdate() ' Find the record that matches the control. Me.FilterOn = False Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Company] = '" & Me![Company] & "'" If rs.nomatch Then...

what is the is null code? You are correct that I'm missing the is null code. I didn't realize I'd also deleted the code to bring up the record. Can someone help with the correct code please whether it be an if statement or dlookup. Thanks! Private Sub Company_AfterUpdate() ' Find the...

This is probably so simple but it's really hurting my head trying to figure it out. I have a form with a combo box that will pull up relevant data on the form. I've added a msgbox to the combo box with the intent that if the company doesn't have any records within the table for a message box...

Import/Wizard If I remember reading correctly on the MS website it's a problem triggered by importing or using wizards. I have a feeling it might have been playing with code that was incorrect/input inappropriately - but not certain. Lesson learned when playing with new features/functions not...

Possible Solution Check out this thread on this site here Unfortunately according to the MS link would have meant that I would have to have found the latest saved non-corupt db and go from there which was going to be a significant pain. However I noticed that whenever VB opened it was on a...

Makes Sense SJ McAbney, Thanks for the input and the sample db, it makes sense. I have forms that users use to input the capabilities so I think I'm going to try and create queries to run the tables you recommend and hopefully that should work.

Try a parameter query Create a form with an unbound text box which will be your account number input, name the form. Create a query using the table that has the information you want to show in the result including the field your searching on. In the criteria of the field you're searching on...

Problem Solved For anyone with the same problem as me I couldn't believe how easy the solution was and how slow I was in figuring it out. I got rid of the subform and had all my fields on the same form, I added a combo box and used the wizard and selected the third option for the wizard to...

I have a table listing companies and their capabilities identified via some 20 check boxes (yes/no fields). I'd like to use a form for users to use to identify companies that match the capabilities checked off. I attempted to do this by creating a parameter query...

Does anyone else experience or can you explain random shutdowns in access? It happens mainly when I'm working in forms and switching from design to view mode. Gets pretty annoying as I can lose work - also will happen when i'm trying to save. very annoying. thanks for any insight

group by & count Another way to do it in the query is select the field with yes/no and then another field in the table (ie item) and do a group by the yes/no field and count the item field. here's a sample in SQL Vies - if you wanted to count how many companies have a website (Website is your...

enough conditions? Do you maybe need code that says join person and join department? Here's an example where I had four conditions that had to match. Private Sub Command18_Click() Me.Refresh Dim stDocName As String Dim stLinkCriteria As String stDocName = "frm_rice_detail"...

Still confused K I need some clarification still - my combo box is now unbound but I can't establish a relationship between an unbound form with a bound form. FYI I still have the subform. Even if I put everything on the same form, how am I linking the unbound combo box with all the other...

I have a form that I'd like to use for 'reviewing/report' purposes. It's a main form with a combo box of company names, with a subform of all the company information. When you use the combo box to select a company, all the cooresponding data loads in the sub-form - which is totally what I...

put in a period I've put in a period (.) or underscore (_) which aren't too noticable and printed that way.

No edits? If you don't want to allow edits, either change allow edits to no in the form properties or lock each field that you don't want to be changed. hope that helps