Search results

Hi, Hope this is the correct forum to ask this in. I'm currently building a DB using SharePoint custom lists. I've run into one issue, where a couple of my list fields are people pickers. When designing my form in Access, it behaves as a dropdown or Textbox and you have to spell the name...

Ya that's actually the exact query I used, but when I try and run it. I get an error that says 'Operation must use an updatable query' I don't know what that means though.

These are multiple spreadsheets, that I need to compile into 1. One is an export from another program. Sorry, but that is the way it is. I need a way to automate the process of marking down if someone has read a newsletter or not for a time periods. Both spreadsheets have an email column...

Hi, It's been a long time since I've really worked in Access. But today I have a project that's been asked and trying to figure out how to do it. I have a spreadsheet with several columns, 'll call this Table 1 columns: Email Address | 10-18 | 10-22 | etc. I then have some metrics I've...

hmm, I guess I'm not seeing how this will work. Here is an example of the information the user will be entering. Campaign1, Goes out in January, March, and September. During the 1st and 4th week. Campaign 2, goes out Monthly, 1st and 4th week Campaign 3, Will only go out 1 time in...

There are going to be separate reports, 1 report would be for Quarterly view. It will need to show all campaigns that are sent in Q1, Q2, Q3, Q4. Campaigns could be for only 1 quarter or all 4 quarters. The next report would be the monthly, Jan-Dec. Campaigns could be run 1 month...

Hi, I've been asked to create a database, to store information about campaigns that go out. One of the criteria is they want to be able to run different reports, that show all campaigns that go out Quarterly/Monthly/Weekly So I'm trying to decided how to store data like this. I started...

Thanks for all your help I think I've gotten it all working!

OK, nevermind my question about the report. I just tried it again, and now it's working. But for doing this for other tables, am I correct about adding the code within the Else if?

Thanks, this is getting me closer. I'm looking at the query1, and I can see how it combines the markets. But when I try and use that query in the report, it treats them as separate records still. Not quite sure why, seems like that should have worked. Next question, I'm going to need...

shoot, I just remembered my tables are linked tables. I've converted them to local tables, so you can see the design.

hmm, I'm not sure if that fits my table structure. The campaigns could have multiple markets, but the markets could be for multiple campaigns too. so Campaign 1 US, UK, Campaign 2 US, TW, UK Campaign 3 UK, TW I'm not sure that works with the structure in your example. Is there a...

thanks for the help, I'm trying to make this work now. What is 'KeyValue'? The report is based off a query that joins my campaign table with the market table, and lookup table. Here is the SQL SELECT tblCampaign.ID, tblCampaign.[Campaign Name], tblCampaign.Description...

Hi, My database has a 'markets' table, where there could be multiple markets per campaign. So right now in my report, it's displaying like this campaign 1 Market 1 Market 2 Market 3 Etc. Is there a way, to Concatenate multiple rows into 1 field. So it would look something...

Hi All, It's been awhile since I'm really worked with Access, and today someone asked some questions about a project and tracking the data in Access. Well I'm looking at Access 2013, and it's changed a lot since the last time I worked with it. I see they've added Apps, and that will work...

It's a SharePoint list so it's only one 'table' The 2 columns I have are 'email' and 'alternate email'

Hi, It's been a long time since I've done much in Access, but I need to run a query and not quite sure how to build it. I have a table in SharePoint that has 2 columns (email, and additional email). There are times where emails in the first column is used, and times where emails in the second...

Link go down to where it says Multi Select Example.

Ya I was thinking of just doing that, but then saw this method of having a unbound checkbox, and was hoping to make it work using that. I have it so I can select them, but not sure how to actually delete them. I might just go with the extra column in the table method.

Hi, I have a continuous form, and using the method I found here. To allow for unbound checkboxes on the form. I was able to get the checkboxes to work OK, I can now put a check on all the rows that I want to select. What I want to do next though, is have a button that deletes all the...