Search results

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?

Yeh, My boss is big into macros, I personally want to study VBA more, I am only an Intern" And eventually do that here. My boss is jsut trying to keep things simple for when we want to use the date/time stamp for another type of macro that prints a report. I am about to try and get this...

HUGE Kudos to you for your help. Serious helper. Now I get to take that date/ Time stamp and figure how to apply it to other macros that print reports. I had just messed with that runcode thing right before I read this post and got it to work. Thank you so much! Bowes

Also, the purpose my my send key "y" is when I run the macro it used to replace the old one and the send key just clicked yes to replace when the macro ran. When I step through the code you gave me it all runs great and creates the file I wanted it to create. I just cant get it to appear under...

Ok, I replaced everything in my macro with what you have above. Now, I want to be able to run this under the macros menu. How can I do that? I eventually want this to run on its own everytime I open up the database. Right now I am having a hard time getting this macro to appear under my...

Still got an error. It keeps highlighting Function AutoExec1() but a popup comes up in red with: yOption Compare Database. What does this mean? code: Option Compare Database '------------------------------------------------------------ ' Test_Locks_macro '...