Search results for query: *

I tried what you said, but got no errors when it compiled. I found another site on the web that said if you had a split db that you could just do a "save as name.mde" file from your mdb file. It appears to have worked, but it makes me nervous doing that. Has anyone tried this...

I have an Access 2003 mdb application. I have split the database and created an mde file. My client asked for a few changes, so I made them in the mdb file and then tried to regenerate the mde file. It acts like it is working, then Access acts like it is done, but has really hung up. I have...

I'm still doing something wrong. It doesn't like me using the word "OpenArgs". I've looked through the list of options on the "Me" object, but none made sense to me that it would store the passed arguments. The closest thing was "InputParameters", but it said I...

I am still not getting this report to work as designed. I am past the original problem, but my report appears to be ignoring my WHERE clause. It brings me all the records that meets the sql statement attached to my report. If I take that sql statement adn attach my WHERE clause in a QUERY, I...

Thank you for your response. I have a ton of experience with databases and programming language, but definitely NOT with Access forms. The development tools I've used did not handle binding in this manner. That was my confusion. Thank you for clearing it up.

Just to clarify that I understand... If I use bound controls in order to let the user select valid options from the database, Access is going to update that information regardless if I tell it to or not? When does this happen? What is my alternative for letting the user select valid options...

I am trying to understand why Access is saving blank records and saving when I'm not calling any save logic! One cause of blank record saving is the following code: Private Function funcClearFields() Dim ctrl As Control For Each ctrl In Me.Controls With ctrl Select Case...

I double-checked, again my names and that was not the problem. I have discovered the problem, but don't understand it. Apparently, Access requires you to have any columns included in the criteria in your select statement as well. This is not standard sql requirements, so it must be an Access...

I hope someone can help me! I've spent all day trying to get this to work!! I have a report menu that allows users to select specific options or all, view/print, etc. I have collected their selections and formatted them into this WHERE clause: lsWHERE = "Assets.EquipmentType = '" &...

Thank you JimbOne! That's what I was missing! I didn't have the "As Boolean" after my function name. Then I didn't realize it was as simple as setting my functionname = T/F. You made my day!! :) Thanks! SCubed

OK, let me clarify a little bit. My function only saves if validation passes. The problem is, how do I send back a value to let the Close Event or Exit Event know to NOT continue? I've tried "Return -1" and others, but the syntax is not correct. If I cannot return a value, then my...

I have created a user function that has all my save logic in it, including some validation. I call the function from various points in my code: Save button, Close button, Exit Application button. My problem is if the validation fails, I need to stop the event which called this function...

DCOUNT was exactly what I needed!! Thank you, thank you, thank you!!! SCubed ;)

I need to get the count value back from this sql select statement from my code: "SELECT count(AssetOwner) " & _ "FROM AssetOwner WHERE AssetOwner = '" & NewAssetOwner.Value & "'" However, I can't figure out the correct command or syntax to get it. I've tried...

OK, I'm getting closer. A Refresh in another area appears to be the culprit. However, now I'm getting a message saying "Invalid use of Null" on a line of code where I'm setting my global variable = Null. I've tried other things to reset the variable, but get syntax errors. How do I...

Glad ot know someone is still awake! :) OK, here's what I'm up against...I have it "somewhat working", but not good enough... In my "OnChange" event, I have this code: Private Sub ComboAssetOwner_Change() globalOldValue = ComboAssetOwner.Value End Sub Then in my...

I apologize in advance for what may seem like "stupid" postings, but I am used to working with much more rebust languages and databases than VB and Access. But, I have to fix what my client gave me, so thus, I'm posting my little heart out to meet my deadline! Here's my problem. I...

I have a combobox containing an ID (the PKey to the table) and the NAME field. The NAME is what is displayed when the user selects a value from the combo box. However, I want the user to be able to modify the NAME and then I need to update the value of the NAME in the database using the ID to...

I'm wanting to grab the internal message (.err object) and then display the message to the user using MsgBox. My question is, where do I get more info about the .err object? There is nothing in the help file or any of my manuals. Thanks again!

I am trying to give meaningful error messages to the users. However, I cannot determine how to know what error message is being returned from Access. Do I use the "err." object? If so, where do I find a list of possible values? All my Access books are worthless! Thank you!