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...

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...

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...

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...

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...

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...

I'm creating a staff calendar type database for a friend of mine, and having some problems with how to create the type of report she needs. Basically because her staff are part time, the number of hours they work during a given week could vary. For example 1 week, they could work 20 hours...

Hi, I have on my form two text boxes, the first text box is unbound and calculates the values of the ID's from some combo boxes on the form. =[combo1ID] & [combo2id] & [combo3ID] so you end up with a number depending on what the combo is example 123 In the afterupdate of this field, I have...

Hi, We are using sharepoint as our backend, and using Access (2007) for our front end. In sharepoint I have certain fields in our lists hidden to users who view via the browser. The access front end is for the admins, and more of the fields are viewable using Access. What is a good method...

Hi, I've been searching the forum on how to create a form that will have a command button, that will allow the user to select a file. AFter selecting the file, I want it to import the file into access. I found this method posted a few times. http://www.mvps.org/access/api/api0001.htm so I...

Hi, I hope someone has an idea to why this is happening to only 1 user. Whenever they try and open the db, they get the following message The Microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time. It then shuts...

Hi, I know I've seen this done before, but now I can't find it. I have a field in my database that has a 13 digit number, I need to find all records that end with 001, 002, 003 etc. Basically I need to find all records that don't end with 000. I'm trying to recall how it's done, I thought...

I hope someone can help me solve this random error, that only some users are seeing with my data entry form. I have a main form that displays the users info. Then 2 subforms, The first subform is the data entry form, and the second subform displays all the entries that the user entered today...

Hi, I just moved my Access tables over to Sharepoint. I'm now using Access and linking to these lists. Basically Sharepoint is going to be the backend, and users can use Access to run reports if needed. Here is the problem I'm running into. I have a query that uses an alias, it worked...

Hi, Just wondering if there are any Sharepoint users here, that are using Access in their sites? Since Access 07 removes data access pages, I've been trying to find another way to display data from a exisiting database on our intranet. We are using Sharepoint, and I think this is going to be...

I just upgraded to Access 07, and I'm working on an 03 DB. I need to create the MDE file, but maintain it in the 03 version so everyone else can still use the db. When I create the MDE tho, nobody with 03 can open it anymore. They get an unrecognized format. Is there a setting somewhere...

Hi, In my db, when the user is entering data they have 3 combo boxes that they make selections from. So I've been asked to make a report that shows the total per user for each combinations of seletions from the combos. For example: a user can select from combo 1 option 2 combo 2 option 1...

Hi, I was asked today if this is possible, when the users are making entries in the form. One of the combo boxes they select is normally the same option for many records throughout the day. What they asked if it would be possible, once they make a selection in the combo on their first...

Hi, I have a main form, with a sub form. The sub form is where the users enter their data. I have it set so it opens with a blank form, and doesn't show any past data. It will only show records based on the current session. I also have the filter properties set to no. I have one user...