Recent content by bowes884

What if its a text field, how would I add the "No Com" on the end of all teh 223s?

I'd like to take a branch number field, let's assume it is "223" and change it to "223 No Com". Is there a way to add the "No Com" on the end of it like that?

Im looking for something that filters information for 6 months prior to any current, non-specific date. Like it will automatically get the data dated from 6 months ago from june, july, or august, without anyone having to go in an change the date criteria. Below is a non working example of what...

have a query with a field that contains numbers with 3,4,and 5 digits. I want to format it so it displays all as 5 digits by adding 0s to the front of the number. EX: 324 4856 45634 change to: 00324 -4856 45634 Help please. Dont want to do it in VBA either. I would rather build it as an...

Ok, I have a series of 4 queries and I want to shrink it to 3. There is a datevalue function that work in one make table query but not the previous make table query where the date is originally pulled from. datevalue: DateValue([actiondate]) is what I use. "actiondate" has a date and time in...

Below is a non working example of what I am trying to come up with. If I could get something like this, it would save me a ton of time going back and updating all the date criteria for my databases. Forgot to post it: >=Now()-Day(180)

Below is a non working example of what I am trying to come up with. If I could get something like this, it would save me a ton of time going back and updating all the date criteria for my databases.

Im more looking for somethign that filters information for 6 months prior to any current, non-specific date. Like it will automatically get the data dated from 6 mopnths ago from june, july, august, without anyone having to go in an change the date criteria.

Is there something I can put into the criteria of a date box to only use the last 6 months. I dont want have have to do this type of criteria: >12/1/2004. I want it to just use information from the last 6 months no matter what the current month is. If anyone knows what I am trying to say...

thank you. I am very new at this stuff as you could already tell. I'm used to writting html somewhat. There my teacher I had in college refered to the code as script. Thats why I refer to it as that. Bowes

Most of it is from a macro I created and converted to VBA. What I am trying to do with it is have Access import a spreedsheet and also tag the name with the date. Any tips?

Option Compare Database '------------------------------------------------------------ ' Pipeline___Trades_to_Access ' '------------------------------------------------------------ Function Pipeline___Trades_to_Access() On Error GoTo Pipeline___Trades_to_Access_Err Dim sNow As String...

I can't figure out how to create a macro that imports a table from one database to another database. Any ideas?

Ive got another date/time stamp question. Is there a way to convert an excel file to an access table and have the table name include the Date/Time? Thanks. I already know hwo to create a macro to convert the excel file to access table. Thanks.

Is there a way to import an excel file and save it as a table witht eh table name including the date/time?