Recent content by roxannep

I need to convert a yes/no field to it's Boolean equivalent prior to exporting to Excel. Dilemma: I have a table I export to Excel. While the table shows -1 and 0 for the Yes/No entries in the table, once it exports to Excel, it changes to TRUE/FALSE based on the data in the table. I need to...

Is there a solution available on any of these forums that does not require me to purchase a separate program? I don't have that kind of budget just to change the few letters throughout the dbase that we need to change.

I have a database that I need to clone and then change a few letters in fields, table titles, etc. (the company name changed, and I thought this would be easier than trying to go through every table, qry, macro, etc., and manually changing two letters in the name). Example: query titled...

JeanW - I should have indicated the titles are text fields (they hold the title of the music piece) just as the composer field is text. So there is no serial number field at this time .... That's where I need the program to auto-enter based on the rest of my description above. Again, this...

I work in Access, but have a request from my kid's HS band teacher and this needs to be done in Filemaker Pro. (Reminder to self: DO NOT VOLUNTEER to help "Create" a database until I know for sure what software they are using!) We volunteers are building a sheet music database (I am the only...

Lupins46 - No, it really doesn't matter if I see the transactions. I was just trying to find a way to hone it down to one Contacts record. Does this make it easier?

I have two tables: Contacts and Transactions. It is a one-to-many relationship (Contacts-to-Transactions). I am trying to come up with an editable recordset in datasheet view using this relationship. The hitch is that I need to display the Contact record only once for any and all times it finds...

I have two tables: Contacts and Transactions. I need a way to filter the Contacts by Transactions over $500. The common field is ContactID in each table. I can easily do a query, but I need to make an edit to the Contacts record. Naturally, all transactions meeting the criteria show up...

I'm not sure I'm seeing how this will then deposit the split name into the appropriate fields. I see how the code determines the pieces, but I need each piece then pasted into the appropriate fields. Again, I'm a novice, so maybe it's not popping out to me where the "John" part is then...

I need to split out some data in one field and have it pasted into separate fields. Example: Fields: NAME, FIRSTNAME, LASTNAME NAME: Bob Jones needs to split out: FIRSTNAME: Bob LASTNAME: Jones and empty the NAME field. In some cases, middle initials are included so how to handle those...

Okay, tried VAL[txtItemcount].... no go, same message. Did I put it where I was supposed to? Message I get: Runtime error: 2105 You can't go to the specified record. Also I had to add the rst! to even get the program to recognize the line (see green text below). It kept erring on me on the...

okay, been trying the code you sent, but on the line: DoCmd.GoToRecord acDataTable, "CSInventory", acPrevious, txtItemCount I keep getting an error telling me it can't go to that record. Is it because we are starting with the last record and telling it to move xxx forward from there...

The key field is actually FileNo, but the field data I need displayed is BarcodeNo which uses the FileNo and a couple of other pieces for a composite identifer (B1140-C0420 ... the fileNo is the 1140). The Barcode data is updated at the RunMacro line, then I need to pull the first/last, so...

WildHare - I think I posted my current code at the same time you posted yours. How do I fit what you provided in with what I have going now? Thanks!

Okay, here is the code so you can better see what I need: Private Sub cmdAdd_Click() ' Roxanne Pratt 14-Nov-2000 ' create multiple identical records for recurring inventory ' add records to Inventory database and clear form for next ' entry of recurring inventory items Dim rst...