Search results

Thank you. I'll look into doing it the way you mentioned, by creating the function. Thank you also for pointing out the 'Like' in my code. :D

OKay, I think I found the reason that my form is messing up, its because on the form, it wasn't the VB code as I suspected, its a couple of list-boxes on the form that have a SQL statement of this type: SELECT Categories.Name FROM Categories INNER JOIN ArticleCategories ON...

I'm creating a database to store a bunch of information on various animal species, and one of the peices of information I would like to store is the migration and breeding dates of the animal. I was wondering if there was a way I could use the Date type for this information, and be able to...

So I have to go through all the code in the original form and change any references from Froms!mainformname!controlName to Forms!mainformname!subformname.Form!controlName ? This is exactly what I was hoping I wouldn't have to do, modify the original form. I was hoping there was some way to...

I have a complex form (in that it contains a lot of VB code and events) to display the information of various articles in my database. I would like to add some browsing options to the form (like a list of all articles on the left, and some different back/forward options), but I also need to...

Bump for a friday afternoon comment....

I have a text box ('DescriptionText') which is supposed to display the 'description' text from an item that is selected in a list ('List6') which displays the name of a habitat, and has the ID and Description fields hidden. I am trying to use the following code to update the Description text...

I am trying to make a combo-box that determines the records shown in a list-box on my form (for navigation of a book database). The combo-box contains a list of all the categories that contain books using a SQL query. But I would like to add an 'any' category to the end. I just don't know how to...

Works great... Thanks a bunch! :D

Hello, I have a report designed right now that prints information about a company from my database and I need to design a few forms that have lists of companies, and where the user can select a company from the list and click a button to send the report for that company to someone via email...

Thanks for the reply... But I think I mis-phrased the question. I understand how to load the form based on a single field, but the problem I'm having is that sometimes the fields that are used to populate the listbox change.. For instance, sometimes the list-box might contain all the companies...

I had a similar problem, but I finally figured a way to get a form that I use all the time to open to a specific entry ONLY when I want it to (otherwise it just opens to the first entry).. I used the OpenArgs parameter to pass the [Record ID] of the company I want to open (only if there is an...

Just another quick question, Ive got a form where I select an option from a combo-box, and then a list box is populated with a list of companies based on what I pick for the combo-box (ie. 'All Companies Exporting', 'All Companies Registered', Etc..). The list-box has 3 columns, the [Record ID]...

I think I got it.. Apparently Left() takes an index from the left, and Right() takes an index from the right, but Instr() returns an index from the left.. Which is trouble when you're trying to use an index from the right.. So, had to switch the expression for finding the right-hand section to...

Hmmm.. It seems to be concatenating the second name if its shorter as well.. Ie. 'A BBBBB' becomes 'A' and 'BB'...

Okay.. It doesn't work as well as I'd hoped :) It seems to be 'stretching' the last name to be the same length as the first (ie. 'AAA B' will be 'AAA' and 'AA B'), although if the last name is longer, then both names are fine.. I can't for the life of me figure out whats wrong... Any suggestions?

Yeay! Success!!! Thanks a bunch for your help, I finally got it working right.. I had to stick the code as an expression in my source field in my append query (where the 'Append To' was set to 'First Name')... Here it is, in case someone has the same problem: Trim(Left([Industrial...

I understand what you guys are saying, and beleive me, I'm with you. But the reason that I need this, is because I'm working here on a contract (which runs out rather soon), and my boss wants me to leave him a simple way to import data from the older (and certainly very poorly designed)...

Unfortunetly I cannot change the primary key.. I am not able to change the structure of the new database. Is there some other way to do it?

Okay... Just where should I be doing the processing? Like can I just stick it in an SQL statement somewhere? Or do I need to create a seperate function and work on the data one entry at a time? Your reply already helps me a bunch tho, I'll keep plugging away at it..... -Cavern