Search results

You could just do it in two queries. The append for the names that are the same and then an update, to update the values of the 10 fields.

Database bloat is something we are trying to minimize in order to provide fast searches throughout the forum. Please do not post the same question multiple times. It turns people away rather then have them help you. If you haven't seen a response in a day or two, give it a bump. But there is...

The easiest way to get around the date format is to use Format() on both sides of the operator. For instance: WHERE Format(tblPicture.PicDate,...) = Format(Me.txtDate,...) It will slow down the database, but in cases where the format is changing regularly, and in cases where a dates are stored...

Go open the table manually. If a login name and password is not required then you should not be receiving any issues. Try Compacting and Repairing the database and Compiling your code. Also, make sure your spelling is correct. Additionally, I've ran into occassion where the database needed...

Please format your code for response.

you might want to attach a copy of what you are talking about so that we can see these phantom characters. It's tough to comment on this since you say the ascii is reporting incorrectly.

First, let me start off by saying I agree with the DOC Man. This whole thing can be done by the use of Queries, which will run faster than VBA. However if you're intent on optimizing the VBA, there is very little code here, which means it practically is optimized as far as it can go. I...

I don't believe he needs to create an object since he used the New keyword. Been a while since i've used ADO though. I'm also surprised "Print xxxx" worked for you. I receive errors when executing it and instead do a Debug.Print

Good for your boss :) Access is mostly superior. As Bod suggested, use the InStr() to find the text that you're looking for and use the Mid$() to retrieve the data. You may still use your arrays to store what you're looking for. However, you should use a multidimensional array instead of...

Me.Refresh

HDD is not a good way to go either. Hope you're grabbing the default HD, since many computers these days are using multiple drives, but now what happens when someone wants to upgrade their HD? They're allowed to install on the new one, or no? If they are.. then that'd be the same as...

Usually I would fix it for you, but my mod powers have disappeared, they should be back soon. An alternative to actually typing is to highlight the code and in advanced mode click the button that has the pound symbol (#). This will place the code tags for you.

SELECT * FROM [Table Name] WHERE [Order]=-1 OR [InStock]=-1 Rhe -1 must be in quotes ("-1") for each field that is of a text datatype.

First, the correct word is "optimize". Next, please format your code so that it is easily readible. That is, tab sequential lines inside loops and conditional operators - this will be the first place to start so that others may help. :)

Explain what you're trying to do. Say you have a table [Dog]. Dog: Height | Weight | Color | Breed Does the one table you wanna copy from have the height/weight information and the other have color/breed info? (Are you trying to combine the data on the same row/record?) Or, does one table...

Yes, but I believe true is identified by a -1 anything other than -1 is False (default 0).

I am still thinking that you do not want either the MAC address or the IP address. Both are networking addresses that may change over time. For instance, whenever a person gets a new network card (or wireless adapter) the MAC address will change. IP addresses are generally controlled by...

IP address is the wrong way to go. Most IP addresses are not static and thus will change and be reused over time. You were correct to assume the MAC Address, which is unique for each computer. However, the best way to go would be to use registry keys and base the program on the...

What the people are saying is correct. The field parameter (the first parameter) must be in quotations. I have also had issues where even if the field name is one word, it must still be in square brackets; therefore, "FirstName" would be incomplete - it would need to be "[FirstName]". To...

There is an HTMLBody Attribute that you can use instead and format your text to however you would like. Instead of .Body, use .HTMLBody = mess_body Encapsulate any bold text as follows: <b>here</b> The "here" would be the bold text.