Search results

This should be a simple one but I can't quite figure it out: I'm trying to make the label.caption vertical. When I set the vertical property to Yes, it displays it as if the label is rotated 90 degress clockwise (the beginning of the text is on the top, the top of the words is on the right, the...

Thanks, Tim! That's a very clever idea. Not the best approach to conquer this nuisance of a problem, but it works fine for me.

I have two main forms referring to one subform. I want that particular subform's combobox to detect which main form it is running under with a series of if statements to perform a function. I tried the Private Sub Form_GotFocus() >>global variable = current form name EndSub but it doesn't...

Access2000 crashes on value asgn; Error: "Method 'Value' of object '_Textbox' failed" I have this add data form. When I click on the add button it runs a series of DoCmd.RunSQL commands to make the additions. It's developed in Access 2002 as a 2000 file. It runs fine on Access 2002, but on...

I have two main forms referring to one subform. I want that particular subform's combobox to detect which main form it is running under with a series of if statements to perform a function. Is there a simple way of the subform knowing which main form its running under? Or if I have another...

Do you have a primary key control on your form? A way to do this is to create a control or text box bound to the ID of table to which the form is bound (make it hidden if you want). On the combobox afterupdate event use the following code DoCmd.GoToControl "txtID" DoCmd.FindRecord...

I have an Edit form that allows the user to move the location of a record. When the record is moved by press of a command button, the VBA code simply runs an Update query to change the ID of the record referring to a different location. Then I would like to refresh the form by this line at...

:confused: I've been having the same problem as well for months now. I thought I got rid of it but its back to haunt me. What I've noticed is that sometimes this problem does not reproduce itself consistently. I am developing a database as an Access 2000 file in Access 2002. I have an Add...

I've been sitting here for the past few hours testing out different methods. I've the link to the tables were originally linked to a location that is mapped. I've also tried the full network path. I've tried placing the the split database FE & BE on the server, and the same thing with the BE...

Thanks, Tim. I was thinking about trying that. I'll do that. Do you run into any major problems if multiple users are accessing the database?

I split my database, compacted and repair, did as much as I could the performance analyzer suggested without compromising functionality and controls, converted the front end into an MDE file and put the BE on a network path (and of course all the tables are linked), with the FE hosted locally by...

It works in the Detail Format section. Thanks, Rich!

I need to be able to check whether or not a value is assigned to a certain field. How do I do this? For some records, some fields contain no value. I need to detect when that field contains a value and make a label visible. (This is for the report's detail section.) I tried several things...

How do you use this line: Reports!NameofReport.Recordource = NameofQuery The report needs to be open before it's recordsource can be changed, and when the report is open (in print preview) it will not allow the change.

I figured it out. I was missing a single word: "form" Me.frmDatasheetView.FORM.RecordSource = "Search Results"

Still haven't figured it out! Please help! I'm trying to display a dynamic querydef in a subform: datasheet view instead of having it open a table view or using a listbox. I tried this: Me.frmDatasheetView.RecordSource = "Search Results" (where "Search Results" is the Dynamic querydef)...

Yes, please. Thank you for your help.

I have a QBF (query by form) that creates a dynamic querydef. I want to display the results in a datasheet view subform. Is there a way to do this? A way around this would be to create an Access query with the dynamic query. Is there a way to modify an existing Access query with a querydef...

I have a search form and an add/edit form. The search forms contains a listbox that displays the results of all the records that fits the criteria of the search. I have an edit button that should take the information (or the ID) and send it to the edit form to (with has a field for the ID) and...

Is there a way to do this (retain the information provided in the fields when adding records) without using subforms? The database I'm creating. Lab technicians place lab samples (each with its own ID) into multiple locations. Each sample contains a lot of data. Often times when multiple...