Search results

Why won't the font work? Maybe I'm not familiar with the 128 barcode, but with the 3of9 I've used it before just fine. You can just set the font to it and it will be correct. There is no conversion or formatting necessary.

Nope - you'd have to create it with the record.

All you need to do is get a font: http://www.squaregear.net/fonts/free3of9.shtml I'm sure that there is a free 128 out there too, just search Google. Why wouldn't a font work?

What is the purpose of the letter at the end?

Well the 2nd text box would simply set the data source to: =[txtBox1].[Value] For the first one...not sure what you're trying to do with the Sum, etc. Continuous form and text boxes in a footer?

To prevent something like this, I use a blowfish encryption algorithm to encrypt data stored in a user table. If the user finds a way to open it, they just see gibberish. Encryption password and etc. are stored in the code, so not accessible (or at least nowhere near as easy). This can cause...

Is the data the same? You could do a find/replace. In the find box, put a * and in the replace box put "" This will do it for the whole table though, not the selection. Can you do a query that will select only these 400 records? If so, you can also use an update query to replace the data.

I hate ULS? :P I prefer to have more/easier control over things. The way I do it, since we are networked, users just open and they don't have to worry about passwords or anything. Granted I have not used ULS much but it is MUCH easier to use my methods if you have a migration or other things...

Well there should be no local tables in the MDE file, save for maybe a table with version info. Other than that, it should all be links to the backend.

You wouldn't be able to remove it while it's open. I use an actual installer package for my DB's so you can remove them from control panel's add/remove programs. I think the only way would be to include a VB Script in an update and have the database call that VB Script, then exit, while the VB...

What do you mean by "make the system remove itself"?

I really need to write a tutorial on this type of thing for people here...I see this a lot. Here is what I do. I have a table with usernames and access levels. Upon login, this table is checked for the current user logged into the computer, and grants the proper access for that user. I use a...

If you did a simple update query, it would show how many records are being updated. I don't know if that would work the best depending on how computer savvy your users are. Otherwise, you can use a recordset and the RecordCount property.

Steve - that code should be in the On Load event for the form, so that when it opens it either shows or hides the button then. That way, the people who aren't supposed to see it don't even know it's there in the first place.

But if you want some users to be able to get to it, and some not, you're not going to make different versions of the front end. And then because that version could just be copied to someone else.

How many people enter data? If only a few, you could do something like the following as long as you are on a network and each person has a unique username: Dim strUsername As String strUsername = lcase(Environ("UserName")) If strUsername = "user1" or strUsername = "user2" or strUsername =...

Yeah they have workstation restrictions and a bunch of crap on the SQL server here. It's annoying.

Oh and you can skip the DSN but put UID and PWD in the code too. Anyway hopefully this will point you in the right direction.

Something like this - though you'd have to re-link tables - and on exit you should remove them. Set sqlConn = New ADODB.Connection sqlConn.Provider = "sqloledb" sqlConn.Properties("Data Source").Value = SERVER sqlConn.Properties("Initial Catalog").Value = DATABASE sqlConn.Properties("User...

The code is right...unless you missed an ' somewhere that I can't see. Are you leaving out any required fields or anything?