Search results

I hope this is a quick question with a quick solution. I have created a DB, that has 10 users, 5 are on site and the other 5 of off site at various locations. In order for everyone to have access I have put the DB on a Network folder, being able to access the current DB is contingent on being...

I have read through a couple of questions about splitting into FE and BE database, I have an odd situation and thought I would reach out to see what the best solution would be. I have created a database that I will have 3-8 users updating and entering info at sponsered events. The issue that I...

Good Morning All, I have a functional question that I hope you all can help with, I am not sure what is the best way to set up information. Here is a little bit of background: There is a National Database which stores information that I work with, but I can not manipulate it or use it in any...

I know this is probably in here somewhere not sure where or what to look under to find it. Basically I have two form entries one called Program and one called category. When a user selects a lookup entry I only want certain categories to show. I have created tables containing these look up...

I have a co-worker who set up a calander for classes and was recently let go. Her account is still active, but I need to get to her calander to share with the new employee taking over her job. When sharing permissions were set up I was only given editor permissions. Is there anyway to share...

Can you link different databases through buttons? For example I have a database named Siezed property and another named evidence. I don't want to have all this information in the same database as there are more than 3000 entries in each one. but I would like for someone to be able to have the...

I have attached a sample of my data. I have a record that has several spots to put property in (i.e. property 2, serial 2, value2, there are 8 data fields like this in each record.) I set it up this way so that a mail merge will include all property for one person. The issue I am having...

Hi all I am not sure if this is even possible, but I thought I would give it a try. I have a basic report for seized cars and a sub report for seized property, The reports are linked by a time frame, i.e. user enters start and end dates. It is very possible for the car query to be empty but...

Any help or guidance on where to look would be great. On my report I have a calculated field for a monthly total cost that reads sum=([total cost]) what I would like to do is subtract this from a field in my table called "amount funded". Thank you for your time

I have my report set up to pull dates from a form, however the query is not pulling the correct number of records since the New Year, for example when someone enters 10/31/2009-12/31/2009 the report returns 100 records, but when 10/31/2009-01/01/2010 only 3 records are pulled. I can't figure...

I am probably overthinking this, but I am doing a form where about 50% of my entries will need to be converted from grams to pounds for a later report. Right now I am trying to use a unbound text box in the form using [weight] * [.00220462262] on the "on click" command, however when I try to...

Ok, I need a little help I am not sure on exactly the best route. What I basically need to do is figure out to output a single record query into a single excel worksheet from an Access form. I have an excel workbook that is set up with about 15 worksheets, that pull their information from the...

I am still learning VBA, and I am having a difficult time trying to figure out the best way to accomplish this. Years ago a workbook called Locator Forms was created in Excel to populate about 12 federal forms. I want to be able to use a Query to pull the neccesary info from an Access...

I know that this has already been presented, however I am really new to using VBA and don't entirely understand the suggestion. I want my users to be able to move a single record from an open table to a closed table, using a command button on a form. Thanks