Search results for query: *

OMG...I figured it out. Your syntax worked....however I had to change how I was grabbing/saving the strDate. I added a line that added # signs to the string: strDate = Left(RSDate("F2"), 3) & "01/" & Right(RSDate("F2"), 4) strDate = "#" & strDate & "#" Yeah...thanks for the help!

Thanks for the suggestion! I tried this and didn't get any errors however when I look at the records that were appended they are a time 12:02 rather than a date.

I tried your syntax (as well as about a million others) and still having an issue. So I thought I would put the string together as I'm grabbing the info and then did a debug.print of the strdate to see how it came out and it looked just like I wanted...04/01/2012. When I went to do my insert...

I have a sql command I'm trying to execute and can't get the syntax correct. I have a temporary variable that is storing a text date (format '04/2012') and would like that converted to a date when it appends. What I have is as follows: DoCmd.RunSQL "INSERT INTO Currentsalary ( [Personnel...

I had been importing just the select range that had the records of interest in them. I just decided prior to your post that I should just import everything and then should be able to grab the date that way. I'm still working out kinks here but I think it's stuff I can handle. Thanks to all...

I receive a report in excel each month that has data I am importing to a temporary table in access. The report has one date in a particular cell (B54) that is the same location each month. In my routine I would like to import the data to the temp table then append all records to the permanent...

So I decided to try and create a named range so that I could just import it and be able to grab the date that way and am having trouble with the syntax. I recorded a macro in excel and copied and pasted so I was thinking it would be simple...not. Here's what I have: With xlApp .Visible =...

I am appending data from a temporary table which was imported from excel so all the fields came in as text although things like salary need to be a number. My solution for this was to append into my permanent table (CurrentSalary) the val(annual Salary) and there is another field which is...

This seems like it should be really simple but I can't figure it out. The format of the report that I receive has the date in one cell at the top and the remainder of the data in another place so I would like to grab that date and store it to a variable to that when I import the data to my...

This is a great idea however it brings into question my entire query structure. Let me explain. I have a primary table that has individual jobs and a related table that has the activity of employees coming and going from that job. The primary table stores job information such as budgeted...

I have two separate forms that will be using some of the same queries. Within those queries I have one parameter which is txtstart that is used in all of the queries. Is it possible to have two separate forms with a textbox called txtstart pass to all of those queries? I am getting an error...

I did a bunch more reading on union queries and it really wasn't what I needed however the plus side of that is now I know a bit more about that. You were right in that I was making this a whole lot more difficult than it needed to be. I just summarized on HR Employee Number and from there...

Well this isn't much to look at and it doesn't work. I'm also not sure it will give me what I need. However one step at a time because I'm still trying to figure out union queries. Here is what I came up with: Select [HR Employee ID Code], [Act Annual Salary] From [Job Activity] Union...

The salary changes were an addition after we had been using what I had which is why there is an annual salary in the [job activity] table. We are not being day to day accurate, so if something happens within a month it would represent the month. So if a salary change happened on 3/12 it would...

The primary table [job activity] contains position information: start date end date act annual salary employee number name cost center ...many others I currently have a query that given a particular start date [txtstart] will give you their salary cost for the time span. I'm going to be given...

I have a query that calculates the actual salary for each month based on the start and end dates of employment. I've been asked to incorporate salary increases. So I thought I had figured out how I would do that. I have a table that gets imported that has personnel number, salary and date...

I found something that would help in the following thread and it worked great: thread702-1358379

I am trying to write a routine that will email from access using outlook. I have it working with a couple of issues. The first is that when emailing from a queried list in access, it needs to check to see if an attachment exists and then email it if it does. The attachments are excel files...

I was rechecking the properties of the form and saw that I had put a record source of [Head Count] in there. I took that out and now the subform won't display anything. What do I put in the record source if I want the option group to determine that? Thanks

So I did have a problem with a few of my queries. Here is what is happening though. The two tables I'm trying to view records for are related with one common field...position number. When the different options are chosen, the position number is the only field that will come up. The number of...