Search results

http://bytes.com/topic/access/answers/810804-code-module-size-limits "Max 1,024 characters per line. Max 6,601 lines per procedure. Max 65,545 lines per module. Max 1,000 modules per database. Max 2 GB file size."

Well provided it is a valid tif file I can't see why it isn't working. Is it actually crashing on the OCR line, or on the create line?

What is that value in TextBox.value?

Way more information needed here, what language did you program it in would be a good start.

Do I don't see where AdminUser is declared anywhere. If you have not declared the variable then by default it is local in scope. Many ways to do this, you can put the variable declaration outside either sub Dim AdminUser as Variant You could also change the Sub to a function that return...

Could you not create a query that is just SELECT * FROM [PassThroughQueryName], then set that as the record source for your report/sub-report?

I'm not certain what the very latest one is, probably shipping with Office 2013 though. I found this on the MS site http://msdn.microsoft.com/en-us/library/office/ee691831%28v=office.14%29.aspx#odc_office2010_Compatibility32bit64bit_IntroducingVBA7CodeBase it explains a few of the differences...

In my personal experience, VBA is not much of an OOP language, it codes more like a scripting language. Now that is not to say it cannot be done to some extent, but many of the common practices in a standard OOP language, inheritance, polymorphism (such as method overloading), etc are not...

One possible issue with this implementation is if you pass in a predefined data type. sub Test dim x as long x = 100 debug.print datatypevalidation_IsInt(x) end sub This would return false even though x qualifies as an integer, because the data type is explicitly a long.

Indeed, if you are compiling into an MDE I would not use the debug.assert. The point of my code was to cause an error if the Cint failed, then exit if it does. It is faster to just check if it converts to an integer and handle the error than to check all possible reasons it may or may not be an...

Cool, I would go with something a little simpler, but yours works just fine. Public Function datatypevalidation_IsInt(ByVal varNumber As Variant) As Boolean On Error GoTo Err_datatypevalidation_IsInt Debug.Assert CInt(varNumber) datatypevalidation_IsInt = True...

So what is the purpose of this, are you only wanting to see if the variable passed in was an integer type, of if any number passed in could qualify to be an integer? I.E. If I pass a long variable with a value of 1500 your function would return true, even though it is not really an "integer"...

Indeed this will be a lot of code behind every button and event, the old saying of "Access don't know what you don't tell it" comes to mind. It would be nice if there were some type of table and/or event level tracking, but alas no such feature is built-in to Access.

Variables are really just pointers to where data is stored in memory on the local computer, so in a multi-user environment each computer stores it's own version of those variables, you should be ok given this situation. However if you have multiple users using the same front end on a shared...

Two ways I could see doing this. Link your Inbox to Access and query the table for the responses, then update your results. Or add VBA code into Outlook and have it scan and update Access when the forms are received.

If you could put text delimiters around the comment field you might be ok, but since these are old files and already set I can't think of an easy way to do this, as my old boss was fond of saying, GIGO (garbage in, garbage out).

Since you are selecting every item in the list, why bother using the selected property at all, put your code in a modified version of the first loop. For i = 0 To Me.ListSelectedNatcd.ListCount - 1 SQL = "UPDATE Mapping " & _ "SET Mapping.FoodEx1_cd = '" & Me.FE1_cd.Value & "' "...

Close with this "WHERE Mapping.Nat_cd = '" & varItem ' "WHERE Mapping.Nat_cd = '" & varItem & "'"

I think the answer is yes, you can have a switchboard that only allows access to certain functions based on the user. This typically requires VBA code to hide/unhide certain components or determine the correct switchboard to open.

What does "server level" mean in this context? Also without VBA knowledge I think pulling this off will be difficult/impossible.