Search results

I'm using MS Access to connect to a MySQL database through ODBC linked tables. It appears that Access (or the ODBC driver) will not process a SQL statement that MySQL has no trouble processing. It is as follows: SELECT recipelabel.labelid, parent1.lbltext, node.lbltext AS LabelPath FROM...

I've got a new problem that cropped up some time ago and only today did I find some critical information about this problem. Every once in a great while, with no consistency, a user will come back to their workstation and find the following error message on their screen: "Your network access was...

I don't know either. In fact, I remain confused on a lot of the default objects/commands in Access. In my opinion there's a lack of consistency on how they are used, what they are used for, etc. However, I've just learned how to use the ones I need and use the most and I don't worry about the rest.

It's true it would probably be better to avoid the checkbox since you really need to try to keep the checkbox and the expirydate synchronized. This means you are doing your work twice and taking up extra space in the database. However, you choose to keep the checkbox, then the answer to your...

One thing that still isn't clear, does every entry in the numeric column always have the "-" sign or do just some entries?

Sorry but I can't help but get hung up on what you're trying to do with that text file. You don't have any control over how the text file is output? Importing a file that doesn't have decent delimiters is really tricky business. I would normally try to convert the "-" in the negative numbers to...

I think this line of code: stLinkCriteria = " Me.text39 =" & "'" & [patientID] & "'" Should be changed to this: stLinkCriteria = "[patientID] = '" & Me.text39 & "'"

Is there some reason you don't have the Call Info form a bound form? If you would make it a bound form you could just open it passing in a criteria or filter statement and it would go to the correct record.

So the file uses a mixture of delimiters? You can't go just by spaces or just by tabs?

You can probably use the SendKeys function although I can't really recommend it. Is this a "post" form instead of a "Get" form? There's no way you can format a URL directly to the page you'd like to go to?

Yes, you certainly can store links to files in Access and I've also had some success opening the files from Access as well. I recommend you open a new thread/post for this question.

The best I can offer right now is a screenshot. It would probably take me a full 8 hour day of work to strip this thing down to a database that could be posted here as an example. Sorry I can't offer more. Maybe someone else has a database/code example how to do this.

I recommend you try to narrow your question. I don't think you're going to get a lot of help with a question that is so broad. There's probably quite a few here that could write your program for you but I doubt that anyone is going to offer to design this for free. Having said all that, I'll go...

Yeah, I'm not sure either where to start on a question like this. Try to narrow it down to a specific problem. What you're asking is already somewhat suspect. No offense but it looks to me like you're cobbling together some kind of solution that will be clumsy and unmanageable. Is there some...

I recommend you use only buttons for input on a touchscreen. If you can make something else work for you, more power to you. I just don't think anything but buttons are good for touch screens. I designed a timeclock system where the user selects a work order and then all of the "work types"...

Well, I'll give you an idea how I would build this, conceptually. You need to create your own function that requires two date arguments and outputs a long number. One argument will be the arrival date and the other will be the ship date. (You'll have to pass these in when you call the function...

BTW, if you want to try cascading combo boxes, take a look here: http://mymsaccessblog.blogspot.com/2009/04/access-2007-sample-database.html

LPurvis beat me to it. I recommend the same solution. I have used it with success.

You could do this with cascading combos. But what you are really looking for is the treeview control which is not native to access, the way I understand. I think this is an ActiveX control that comes with Visual Basic 6. If I err not, your best bet to obtain it legally is to install someone's...

I recognize that you've found the problem already but I just want to mention that I think you should use Option Explicit in your code. You're referencing fields and functions that don't even exist. Maybe it's just because you stripped out stuff, I don't know. But I personally feel that the lack...