Recent content by radshar

Ok so what you said here below, was just that I should have the need to only update the status at the group level, correct? However, there is a little more to all of this, I need to see the new status at the client level also, so once I update my group table with the new status, I need to be...

Question... is it possible to do a vlookup in a table field to grab from another table.

I was able to figure out the appending sorry! now im going to try what you've said above :)

The group information is not managed separately. the excel file that is uploaded contains the group numbers and status'. That said, is there a way for me to create an append query, that will take the group numbers from my cumulative table an move them to this new Group table, so I can manage the...

Hello I'm creating a database where I have a set of data imported from excel. There are various fields in this table. Each record represents a client, which contains a group number that they pertain to. For example: Name: Jane Doe Group #: SD123 Group Status: Completed Name: Jack Black...

Hi! It looks like this would give me a prompt displaying what was uploaded. I'm actually wanting to take this a bit further and have that infomraiotn within a table in access, so we can log what was uploaded, incase a day was ever missed...etc.. any ideas?

Hello, So I have 2 Tables -Daily_cumulative -tbl_Import I have a button macro in my form which when pressed prompts me for the file I want to upload. The data is uploaded to Daily_cumulative. tbl_Import should display for me the name (or path) of the file I just uploaded as well as...

Ok I might have done something wrong. This what I have: 2 Tables Daily_cumulative tbl_Import I have a button macro which when pressed prompts me for the file I want to upload. The data is uploaded to Daily_cumulative. tbl_Import should display for me the name (or path) of the file I...

Hi! I'm not sure I follow your question.... Below the last and only entry there is nothing there, is htat what you mean by 'FileSource field is Null?"? thanks again for all your help!

THanks, the code is stopping at the below, with the error "sub or function not defined"...any idea why? [CODE]r = StartDoc(psDocName)[CODE]

Hello, I used the following code below to open an excel file using a button in a form. I want a similar button to open an exisisitng PDF fillable form. How do I change the CreateObject to Adobe? Private Sub PL_Submission_Form_Click() Dim xlApp As Object Set xlApp =...

Amazing!! that worked to clear the error!! thanks guys :) But now it wont update the table....ARGH!! there I no winning for me here is there lol

Hey, So I'm still getting an error...."Expected: end of statement" Any ideas why?

Hi! thanks this was great! I was able to use the code but I had to remove: "WHERE tbl_Import.FileSource IS NULL " Now whats happening is that the previous entry is overridden by when a new import of data is completed. I actually wanted to keep a running tab. I'm assuming what...

Hello, I'm using the below code to import data into a table daily. I would like a way for me to log the date and time of each import. Is this possible? Ideally I'd like a table to have the list of each import (they had different names), and the date and time. In the code below...