Search results

I got this code to wrok. Is there a more elegant way of doing it? Private Sub btnSearch_Click() If DCount("ParticipantID", "tblParticipantDetails", _ "ParticipantID = Forms!frmPrintAllReports!txtSearch") > 0 Then DoCmd.OpenReport "rptAthensQuestionnaire", acPreview, , _ "ParticipantID =...

I KNOW What the problem is now. Just not what to do! I realised the difference between the dummy database and my database is that on the close report event I have the text: Private Sub Report_Close() Forms!frmReportView.Visible = True End Sub I have this so when the research assistant...

If Me.Control1.Value = 0 then Me.Text1.Visible = False Else Me.Text1.Visible = True?

Im not sure what you mean by stepped through the code but when I went into the VBA editor and clicked on step into etc.. nothing happens, when I compile the code nothing happens either. The code doesnt seem to be breaking at any point it just isnt doing what I want it to.

I apologize for being so vague. Okay here is my problem. When I set a single button on form to use the entry in a text box on that fomr to OPEN and filter (multiple) reports it works fine - as so: Private Sub btnSearch_Click() If DCount("ParticipantID", "tblParticipantDetails", _...

http://www.techonthenet.com/access/switchboard/startup.php Here you go.

Unfortunately off the top of my head I cant remember what the old versions look like for 2000 etc now that I am using 2007 but basically look on the menu for a sub-menu where you can manage relationships and there is also a section for start-up options etc. Its there you can specify what form...

Ive have seen a number of threads on this but I cant seem to get my button going. Basically the structure of my forms/database is that there is a switchboard on which there are two buttons, ones to a form called "Data Entry View" each of which has a button for each form that when clicked opens...

Thanks. So you mean for check-boxes 0 is an internal recording keeping thing for access and does not denote an unchecked boxed when place in the field default on the form?

Thank you everyon! I will try this,

I stupidly designed a series of forms in a 17 inch screen not really thinking that the program would be used on a 15 inch or so screen. I had the settings ( border size resizable, auto-centre, auto-resize and popup) so the lines are very clean and although I dont really like it I will out in...

I have a number of fields that hold values (scores - either 0,1 or 2) that need to be summed but in some cases the value is 99 (which is recognised by our stats program as a N/A type of anwer- This occurs when a question is optional and the user hasnt answered it. I did not want to value to be...

I found that going to the table design and choosing number and then single --> Standard (I think this is under format type)--> 2 would allow me to keep 2 decimel points without rounding.

Thanks. I understood this part I just wasnt sure where to place the second smaller part of code (the one not in the module). I tried but it didnt seem to work me?

Sorry I totally missed what the solution in. Im slow on this front :) So we are supposed to change our auto number field to a long interger Place this code in a module: Public Function IsNothing(ByVal varValueToTest) As Integer '----------------------------------------------------------- '...

Im sorry that I havent had a lot of time to think about this last week but I will try and solve the problem this week.

Im not a database guy but in the three classes that I took in a database management subject as part of my masters that looked at access the teacher was very against macros (cant even remember why) and I have never touched them since.

Hi I know this is probably a silly question but I had a number of checkboxes in a table and had set their default value to be 0 however I did not do this in the table properties of these fields. I can understand some things like formatting dates in a form but storing it differently in the...

Why would u have three tables but one form? what are the tables for? If you have a form that has a record source a particular table and there is not filtering on you should be able to see all records. Now if u have one table that is connected to two other tables and u want to automatically...

I have a field in my main form that shows values of BMI which is calculated from the users height and weight which they entered on a form attached to the same table. I have a query called BMICalculation which is attached to this field using =DLookup([BMI Calculation, "BMI Calculation"] etc...