Search results

I just did a quick check..... Use the File -> Import and select File Type -> .xls then select your file name. An import wizard will launch. The wizard will take you through several screens. On the third screen the wizard will ask you information about the fields you are importing. There...

It might be easier just to display the records as a datasheet or using continuous forms. That way all the records are displayed and you don't have to mess with the list box. HTH -Al

you might also have a syntax problem. There are several criteria that go with the DoCmd.Close function - DoCmd.Close acForm, "formname", acSave or acSaveNo check HELP for more information HTH -Al

you will need to create a function that uses recordset and do a loop to check for NULL values in the fields. For instance: Dim rst as Recordset rst = "some SQL string" that returns the fields you want to check for Null rst.movelast rst.movefirst (this populates the recordset) DO IF IS...

A clarification question - how are you displaying the record that the user selects from the subform? Is it on the parent form? This will determine how you filter your recordset.

What do I need to do to convert VBA to VB script so I can migrate a database to the internet? Is there a utility I can use?

I need to migrate a database from PC based with tons of VBA code to the internet. What is the best way to convert the VBA to VB script? Are there any utilities that do the conversion? Thanks for your help!

you can develop a query to base the lookup form upon. Set the query field criteria for that particular stone to true and the query will only return the records with that stone checked. I've used this technique with classes that our company teaches. That way we can track who has attended which...

I think your base problem is going to be how are you setting up your initial table relationships and what are going to the key(s). As long as you can drop the dragged item into the "many" table, I don't know why it wouldn't work. It would consist of moving the data from the initial table it...

I can't say that I have an answer for you. However, something to consider when updating a group of records is to use an update query. If the same information is being changed in multiple records you can write your SQL update to use the checked fields in the WHERE clause. UPDATE <field> TO...

I've read through your series of posts with Colin and am not quite sure what you're trying to do. First - is it necessary to display the hospital code on the form your designing. Second - storage of the hospital codes is done in the table. Where are you entering the hospital codes? On this...

Could you provide a little more information about the subform on your switchboard. I'm not sure what you mean. I don't if I can help, but a little more info would be useful. I would think that from the switchboard you would go to a parent form that has a subform. Is that what you are...

glad I could help.

OldSoftBoss, Thanks. To answer your first question - the colors are getting distorted. I have the picture size mode set to zoom so I don't think that is the problem.

How about using a pop-up that displays the date and asks the user to verify and then gives them the chance to move on or to make the correction. Just an idea.

I have .bmp graphics files linked as background images on forms. When the form opens, Access is doing something to distort the image. I think it might be a default pallette problem, but am not sure. Any suggestion are appreciated. The boss man is getting impatient and we have to show this to...

When I embed a .jpg image as the background picture of a form, the graphics filter converts it into a .bmp. My applications are getting too big because of this. How do I create a Web-like form with a .jpg image? An additional thought (7/17/02) - is there a way to have one form as a permanent...