Search results

You could just surround the releveant parts of the code I supplied with IF inputNumber <> "" then ' relevant code here else temp = "" endif I think this is what you're asking.... :confused: Edit: Oh, and as a side note, that function relies on having 10 input digits, regardless of...

A very valid suggestion, and I did consider doing just that. However some of the tables, while almost identical in structure, serve very different purposes (further than simply having different field names) from an overal design perspective. Dealing with these tables with common code is...

Hey, I've got a Date/Time field in a table that I would like to populate with the Current Date/Time. Is there a VBA function that will return the current date/time in a format that the tables Date/Time field-format will like? I really wish there was some sort of topical VBA function...

Here's a solution I just threw this together real quick, so it may not be squeeky-clean--I actually needed a function to do this as well ;) You can add any criteria you want in the select statement. Public Function FormatPhoneNumber(inputNumber As String) As String Dim phonenumber As...

Good question...the forms that I'm dealing with are in a sense "multi-purpose." At the same time though, they are fairly complex, and backed by a LOT of code. Some of the tables I'm dealing with are very similar in structure (Example: tbl_Strategy******* and tbl_Initiative*******--about 8...

Here's a pretty general question...My current database project to starting to get huge in terms of its interface and the code that supports it. Thus far I've been putting all my code right in the forms for the project. Is there any compelling reason to use code modules rather than just putting...

Oh sorry...in a table (hence posting in the "Tables Forum" ;) ) I want to change the table's caption for use as a header in a listbox... Thanks, Sam.

I need multiple queries because it's not just one form that I'm populating with data. I've got about seven or eight different forms that have up to 10 controls which need populating--and these forms will be opened and closed on a fairly regular basis, making speed and efficiency and issue of...

Hey Pat, sorry for the disjointed nature of my description--I knew it sounded a little off. Anyhow I am in fact creating one query right now, but I am modifying its SQL code dynamically (thereby eliminating any advantages of a querydef) because there are definitely structural differences in the...

Is it possible to change a field's "Caption" at run-time? Sam.

You could do something like this: Private Sub Text0_Change() If Not (IsNull(Text0) Or Text0 = "") And Not (IsNull(Text0) Or Text0 = "") Then Me!Next.Enabled = True Else Me!Next.Enabled = False End If End Sub Private Sub Text1_Change() If...

Hey folks... The database I'm currently working on is not overly large in terms of data (less than 2000 rows in total accross all tables), however it's fairly comprehensive in terms of its interface. I currently have 21 tables--all linked. Two of these tables are the MAIN data items, and the...

Thanks for the help pat! For anyone else who is reading this and might be interested, I think I may have stumbled accross something more along the lines of what I'm looking for...The 'parameters' property of the QueryDef object allows you to assign values to a QueryDef's parameters at run time...

One final question...(I think) Sorry to bring this thread back from the dead, but I just have one last question with regards to QueryDef's. Lets say I have the framework of a query (qry_Test) saved as follows within access: SELECT testID, testName FROM tbl_Test WHERE testID = 1; Now I want...

Thanks! Perfect! Big thanks to both of you! Sam

I feel like I'm asking more than my fair-share of questions on these forums--you guys are just too helpfull! :D I'm looking to implement one of those commonly seen constructs whereby there are two listboxes beside each other with an "Add >>>" and a "<<< Remove" button between them. The right...

The MSKB example By the way, I don't see how the MS KB article's example takes advantage of pre-compiled queries, as it appears that the SQL code is being built dynamically within the code in that example. Can someone explain differently? Sam

I'd like some info on doing this if possible... Do you have any example code? I think I have an idea of how I would work it but would like to see how it is already done... Thanks, Sam

Ahhh! That's exactly what I needed to know--thanks. So then, would it be most efficient to save SEVERAL queries, and use the apropriate querydef in the various search situations, or just create my queries dynamically at run time and suffer the performance loss there? Thanks, Sam

I must be deficient or something. I'm searching for QueryDef stuff on this forum, but all I'm finding are posts that talk about "how much info is on this forum about QueryDef." I am getting very frustrated :confused: If anyone can help me out here, I would be very appreciative. Sam