Search results

Hello, I am creating a database that is used to track lots of different types of documents. Such as letters, reports, books, etc. However the actual tracking of the transactions of the documents is identical. Which scheme is best. Scheme 1: Each type has it's own table with it's own unique...

Hello, This is a weird problem that I am stumped by. I have a combobox that automatically filters the form after something is selected. This is a tabbed form with tabs separating information located in the same table. For example, the top 10 fields appear in tab one, the bottom 10 fields...

Sorry I was not more clear, I see now that you're correct it does not show that on the properties window. However, open your Visual Basic Editor window for the form (where you see the Calendar_GotFocus code). On the very top you should see two pull down menus, one on the left and one on the...

Use the on Click event for the calendar control: Private Sub Calendar1_Click() Me![birthday] = Me!Calendar1.Value End Sub

Using VB Code I attached this to a button: Private Sub btnOpen_Click() Me.btnOpen.HyperlinkAddress = "C:\Folder\Files\File.xls" End Sub You could also just have the HyperlinkAddress automatically on the button, this is edited code... in the actual database the user...

Fixed it myself... forgot a line of code that is important it seems. ItemData needs to also be set to the correct value, so the code now is: For i = 0 To lstTest.ListCount - 2 If lstTest.Selected(i) And move = False Then lstTest.Selected(i + 1) = True lstTest =...

Hello, Weird thing with Listboxes here... I have buttons that allow me to navigate up and down a listbox, the following: For i = 0 To lstTest.ListCount - 2 If lstTest.Selected(i) And move = False Then lstTest.Selected(i) = False lstTest.Selected(i + 1) = True...

I think it may also be the inverted way, he may have a main form where he can add and edit tournaments, and then a subform where he can select each team that is signing up for the tournament. The one to many relationship would still be the same I believe, each tournament can have many teams...

For that example that is the best way, to have a field it seems. I guess you would manipulate the forms to make it so that the instructor is attached to the course itself, and the students are attached elsewhere. I imagine both Instructor and Student have to go through the junction table...

Can you use the same code as I suggested earlier, Wherever the code is that makes your form open, just slightly edit it so that: If me.warning = false then Continue to open the form as normal End if This should stop the form from opening if the checkbox is checked.

Hello, I was taught that having a loop of relationships is a bad thing to have. My dilemma comes from the following: I have a table let's say that has user data, which contains a field for Province, and City they live in. Now, clearly City and Province have to also be related. This would...

I think you might have been able to get away with: qstr = "SELECT * FROM Serial_Numbers WHERE Serial Like '" & Left(seria_nol, 1) & "*'" Instead of using a select statement to write the SQL. Note the single quotes.

Ok, I am going to assume that the checkbox is stored inside your table, and is located on the form. I am not sure when exactly you want this error message to appear, so for now let's just put it at the end of them filling in "Vacation End Date". Go into form design view, go into the properties...

If that checkbox is stored in the table itself as something such as... warning...then you could possible do this in VB with. If me.warning = false then If now()-[Days End] > 1 then Display Message End If End if So if the checkbox is not checked, it will then look to see...

Building a query would be a good idea to get your query string, however you're gonna want something roughly like this. Dim stDocName As String Dim strWhere As String strWhere = "[tbl].[Date1]>= #" & [Forms]![frm]![txtStartDate] & "# And [tblOccHealth].[DRequest]<= #" &...

Here is a link to the other thread in which the guy was having the exact same problem as you: http://www.access-programmers.co.uk/forums/showthread.php?t=163451 Apparently having formatting (You removed the input mask, but what about "Formatting" in the table itself from that field?) can have...

Try taking off the all caps in the format in the table input mask etc. (The >) Someone else just had the exact same problem, and it appears to be caused by the uppercase formatting of the field in the table. Although I haven't been able to duplicate the error on my version of Access (Access 2003).

I quickly created a database with a table that had the format as > and put in 5 pieces of random data. I created a form and the combobox that looked up that data and it worked fine for me. I am using Access 2003, which version are you on?

Weird, I ahve not come across that before... I have no further explanation :(

INteresting enough it sounds like roughly the exact same problem as here: http://www.access-programmers.co.uk/forums/showthread.php?t=163413 When you select this empty combobox, can you view the query to see if there is any data that way? If the query shows data but the combobox doesn't, it...