Search results

If you are in the design mode in queries, i don't think the fact that you don't have a 1 and an infinity sign mean that you're not one to one - it simply means that you're not enforcing relational integrity. Have you looked at the resulting data for the query to determine that it really was a...

Its an unbound combo box...

Hello, I have an unbound combo box in the header of a continuous form. The box is set to value list, and when you select a value, the recordsource of the form is changed. This works fine. However, if I there are no records in the underlying form, the combo box is blank. If I check the value in...

Try canceling the update. Put Cancel = True after your messagebox.

What is the code you are using? Depending on how all of your forms, tabs, and subforms are set up, you might want to try refreshing things on the After Insert event of adding a new witness...

First, change this to run on the BeforeUpdate event. Then, use the code below: If answer= VbNo Then Cancel = True me.LastName.Undo Else End If

strSQL = "SELECT * FROM Computers WHERE Computers.Serial = '" & Serial.Text & "'" Also, are you sure you want to use the .Text property? This captures any uncommited value, and could be null. I'm thinking you really want to use just Serial or Serial.value.

Well, the problem with doing away with the checkbox, and using one field to store all of the reasons for the issue is that you lose the ability to search for one or a combination of issues. If you want to have just one field for reports, try adding a field to the recordsouce of your report...

I don't understand the question... what would the single field contain, and how would it fill this field if you have multiple items selected in the list box?

Search Cascading lists, or click here.

The only way I can think of to do this would be to set up another field on your table. Name it SortOrder or something like that. Then you can put either letters or numbers in this field at the records you want to display first. Then, sort by the new field first, then the name field.

Hello, I have a form that I use for navigation in my database. It consists of links to the left to swith between forms, and a subform in the middle. When a link to the left is clicked, I run code to switch the source fo the subform: me.subfrmFrame.SourceObject = "frmSubCustodian" I want the...

Brilliant, thanks!

Hello, Try this link: http://www.fontstuff.com/access/acctut10.htm Its not exactly what you need, but you should be able to figure it out.

Ah, you'd think so! But that's what I was tyring to say - for some reason, Bangladesh was NOT becoming the currently selected record. The label I was using had a "space" in the hyperlink property, to cause the hand icon to appear. I think that was the problem, as when you clicked the label, it...

Hello, I was wondering if someone could point me in the direction of how to have a form open to the record it was on when it was closed. I know I've seen how to do this before, but I've spent some time searching and I can't seem to find it again. Thanks, Eric

That did the trick!!! Thank you so much! I forgot you could make buttons transparent!

No, I'm not guessing at the syntax. I just have no options. I open an unbound form, and set an unbound textbox on that form to the string I build in the code. Its an easy way to display the information so it can be copied and pasted. However, if it were a bound form, and I used your code, it...

This is the code: Dim strInstructions As String strInstructions = "BNY A/C " & Me.txtBnyAccount & vbCrLf & vbCrLf & _ Me.CountryName & vbCrLf & vbCrLf & _ "Security Instructions:" & vbCrLf & vbCrLf & _...

That works, but it sort of goes against the look and feel of the rest of the database. Any idea on how to make it work using a label?