Search results for query: *

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 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 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 = '" &...

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...

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...

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 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!

Based on the selection in a combo box, I need to execute a query that will read a different table based on the selection made, then populate a text box field on the form. EXAMPLE: AssetID is my combo box. User selects an AssetID in the list. After the selection is made, I need to query my...

I have read every combo box sync problem posted and have not successfully been able to get mine to work. I am close, but that's about it. Here's the situation: Combo Box 1 name = ComboEquipType Combo Box 2 name = ComboSerialNumber ComboSerialNumber has a Source Type of...