Search results

You have the right syntax. Maybe it doesn't like your name? Change the query to qryDataRoaming Who knows sometimes about the name things. :confused:

Mike, To Zip the file... Try Tools, Database Utilities , Compact and repair database. Then try to zip it. That will shrink the database down to a smaller size. From your post: "Populated Box 1- click on Name of Song Populated Box 2 click on Name of Hymnal, only displays hymnals from that...

Mike, Maybe I am not thinking clearly. :confused: If you have a combo or list box that you can select the different type of hymnals in it, and then a subform which shows which songs are in that hymnal, does this not accomplish what you are trying to do? Why would you need two list boxes...

Ahh! There you will have to delve into Combo Boxes Based on Other Combo Boxes. Take a look at those threads to give you an idea of what to do. Or you could have a bunch of IF or Case statements in the Combo boxes, such as stating that since you selected a Dwarf, you cannot be a Mage, etc.

Lubos, If you want to dynamically name the file to be imported, I suggest that you create your own topic with that title "Dynamically named CSV imported into Access" or something like that.

My computer will not let me import a text file that looks like an Excel file. "Run time Error 31519 You cannot import this file." ****** Sometimes, helping people rethink their lives will make yours better! :eek: Maybe your company needs to rethink the whole strategy of why you are importing...

Ok when I look at this, this is not a complex database. This is a simple database. Sorry if I have confused you. You will not need to have ID numbers in the Gender, Class, Professions tables. You just list the Professions in their table. You will have one main table to enter data to...

You can import a CSV file, but why would a csv file have an xls extension? Wouldn't it then be an Excel spreadsheet? The DoCmd.TransferText option is what you use to import or export text files from/into Access. In a command button I setup: DoCmd.TransferText acImportDelim, , "Invoices"...

I think that you forgot the = False in the last me.Option134 part.. Private Sub Frame127_BeforeUpdate(Cancel As Integer) If Me.Option130 = False Or Me.Option132 = False Or Me.Option134 (Forgot the = False) Then MsgBox "You have not answered this question" End If End Sub

RuralGuy, Wouldn't you want the AfterUpdate event? That way the msgbox or whatever she uses to alert that the box(es) are unchecked pops up?

Patrick, Don't over think what you want to do ;) You were mostly on the right track with your sample. Create the Character table. Just list out ALL the options that you can have for that each character. Setup the Profession table with all the available professions. The Class table with all...

Patrick, http://support.microsoft.com/kb/209534 http://databases.about.com/od/specificproducts/a/normalization.htm http://www.fabalou.com/Access/General/Normalization.asp These are a good place to start understanding Normalization. Access for a simple database, is very powerful and easy to...

From what I played with, the sample you have will return with a blank also. And then you cannot do anything, except return to all entries. The sample just doesn't blank out visually. I would try to limit my search to a specific field or find a different search sample.

Ok, That was much easier than I remember! :o Just create a listbox using the Access toolbar Wizard The first thing it asks (at least in Access 2003) is List box Wizard is 3 things, you want the bottom one. "Find a record on my form based on the value I select in my list box." Click next...

You wouldn't necessarily have to put in a separate code for each SQL. But the Case would help make the SQL code. From one of the sample Databases (from Kenhiggs I think) on this site. From a On Click event on a button strSQL = strSQL & " or " & "(tblMyData.my_color)='" &...

It might help us if we knew what it is you want to do and what the code is doing now.. Does anything come up? Can you narrow down where the problem is in the code? You have so many SUB's in the code it is hard to tell what you are doing where. Or you could check out the Samples on this site...

Could you use a Select Case ? You could have the Cases setup where the criteria changes based on the <, >=, =< or between, etc. EX) Function Bonus(performance, salary) Select Case performance Case 1 Bonus = salary * 0.1 Case 2, 3 Bonus = salary *...

I am not sure, but you might need to requery the subform in the combo boxes After update property. An example from the sample databases on this site show this.. EX) Private Sub lboEmployeeID_AfterUpdate() Me.sfrmEmployeeID.Requery End Sub srfmEmployeeID is the subform lboEmployeeID is...

Check out this quick DB.. Other threads.. http://www.access-programmers.co.uk/forums/showthread.php?t=129847

It looks like to me you have a great setup for a form/subform instead of list boxes. With your table design and the one to many relationships from Hymnal to Hymnal songs, you should have an easy time setting this up. Why try to make something hard if you don't have to? :)