Search results for query: *

Doesn't seem to work for me. Does anyone have a step-by-step example of creating a combo box? I am fairly new to VB.Net and want to make sure that I am not missing a step. Thanks.

Does anyone know an easy way to auto-populate combo boxes as you type? For example if you want to select the name 'Smith' from a drop-down list - if you type Smi - it will take you to that value automatically. This is easily done in Access, but I'm not sure how to do it in VB.NET. Thanks in...

Thank you so much - that did exactly what I needed it to!! [smile]

That didn't seem to work - this is the error I received: Server: Msg 536, Level 16, State 2, Line 1 Invalid length parameter passed to the substring function.

I would like to "hide" the last 5 characters of a field when it displays. I have done this in Access using the LEN function: User:Len(Primary_User - 5) - but that doesn't work in SQL. Does anyone have a simple solution for me. Thanks for your help.

I would like to make a copy of one of my existing forms within the same application. Is there an easy way to do this? I want both the code and the design of the form. Thanks for the help.

Is it possible to use a job to import a comma delimited file directly into a table? This job would need to run nightly. Thanks for any assistance.

Thanks to everyone for all of your helpful hints. I was able to get it to work for my purposes!! [smile]

I want to be able to use this query every day, so I don't want to have to type in a new date every time. Is there anyway I can format the GetDate() to grab values on the date only??

I want a query that displays all results entered on that day. This date is entered into the database via a GetDate()default value. Now that I want to get those results back out...I am having trouble because of the time that is affixed with the date in the field. I just want to grab results...

Thank you for your quick response. That was exactly what I needed to know!! [SMILE]

How can I use a stored procedure to select a record that was just added to a table? I want the most recently added record... I'm sure that there is an easy way to do this, but I am new to this and can't seem to find a solution. Any help would be appreciated. Thanks very much! [smile]

Thanks for your ideas.

I am using Stored Procedures and Triggers to move data from a "temp" table to the "real" table. Once the record is moved from the temp table to the real table, I want to be able to delete the original record in the temp table. I have had success with this when I use the "delete from temptable"...

Never mind - I figured it out. Thanks for your help with my original question. [smile]

Thanks for your help on this...I have one additional question for my full solution... What I am doing is using the SendObject function to send a report to a list of emails - from the table I was referencing earlier. I want to be able to send a specific page of the report based on an ID...

I would like to open a recordest (from a table) and use those values in a variable string. I am using a select * statement from my table to open my recordset. How can I capture the values of that recordset into a variable? Any info would be much appreciated. Thanks

Thank you for your help. That code worked like a charm!! [smile]

I've tried that and it doesn't work. Here is the code that I was using in my .mdb that doesn't work in my .adp... Function CopySelected(frm As Form) As Integer 'This function inserts the selected emails into a table called EmailTmpTable Dim ctlSource As Control Dim ctlDest As Control...

I would like to use a multi-selection listbox to select values and store them in a table. I was able to do this in Access, but am having problems doing this in Project. Does anyone have any suggestions?? Thanks.