Search results

I swear I've done this before, but can't seem to be able to figure it out now. I'm trying to restrict the users from making edits to a query, either from changing the data already entered or from adding new records to the DB. I know how to do this in a form but how do I get it done in a query...

I built a database for my company which services interest only loans for construction companies who need quick capital to build then get paid and pay off the loan. Everything on it works great except one part, and I can't figure out how to finish it. My database generates a payment schedule on a...

Hello, So I have a simple question, if it can be done easily then please tell me how, if it cannot then fine. On any access form there is a Navigation Bar that tells you which record you're on out of how many records are in the table or query, a filter option AND THEN a search bar. The search...

Okay so I feel like an idiot b/c I can't get this to work but I'm out of ideas. When put into SQL, it works fine, but when on a control, it has issues. Here's what I have: =DLookUp("Location","tbl_User, tbl_AssetLocation","tbl_User.AssetLocationID = tbl_AssetLocation.AssetLocationID AND...

Hello Everyone. I'm trying to create an update query and have been failing. Here's the scenario - I have 2 tables: Order & OrderBreakdown. In my Order table I have a field named TotalCharge, the field I want to update. The OrderBreakdown table has InventoryID foreign key in it as well as a...

I'm trying a print report command that first looks to see if a particular document has been printed. This is kept in one of the tables if a Yes/No field called "Print1". I'm trying to tell my If-Else Statement to look to here and if it is Yes (-1) then display a Yes/No Message Box. Everytime I...

Hello, So I did this is Excel and now am trying to get the same result in an Access query. So in Excel I am using a math function; a set number(60)*the value in the previous row. i.e. - 60*[Balance]. So if I have 10 rows, the first row will get the number from another field and beginning at the...

Hello All, I have 2 fields, one is a Foreign Key field and the other a Name field. My query shows only one foreign key value at a time (i.e. all = 25) but I have have 3 or 4 Name records with this key. I want my query to take all the names I have in my Name field and group them together...

So I have 2 tables and I want to Insert only 1 value into my second table as long as it doesn't exist. So if 'LeaseID' in table1 = 201 then I want to insert 'LeaseID' into table2 only if the value 201 does not exist in table2. If it does exist then my statement should "attempt to update 0...

Hello Everyone, I've had this problem for a while now and I've gotten around it by having a button that closed and reopened the form but there has to be a better way to do this: When I filter a form, I can't filter it again with a different value until it is closed and reopened. I have been...

Hello Everyone, I'm trying to put a couple documents onto an Access Report and am having trouble. The first is a word document and I tried to just copy and paste it but this leaves the document on the Report really small. Is there a way to copy and paste it so that it stays the correct size? I...

I have a query that shows everything I want it to except give me a Descending count. I have my criteria on it and it's sorted the way I want, now I just want to add another column that begins at 1 and counts down from there. i.e. - If there are 5 records in my query, this new column will show...

Hello, I'm trying to take a couple Microsoft Word documents and put them into an Access Report. When I try to copy and paste, Access shrinks my page. What do I need to do in order to get it in there and keep it the same size? Thanks

Hi everyone, I have a little problem. So i'm working on a DB where it keeps track of loans and if a balance is still unpaid after 10 days then a late fee of $100 is added to it. The code in red below I have running on Open of the form and it works but obviously it updates EVERY time you open the...

Okay so 2 problems, first I want to apply a filter to a bound form that shows the dates that lie within a specific range. That range is the current year, current month and any day. I can't figure out the correct VBA for it, below is what I have. DoCmd.ApplyFilter , "[DateEnd] = Between...

Hello Everyone, So I have 2 forms, nearly identical to each other. On the first form the user finds the record they want by the field "LoanID" and if they wish to edit the loan information they click a button which opens up the second form. What I need is for the second form to open up to the...

Here is my problem. I have a lot of different fields that all revolve around two date fields, BeginDate and EndDate. The user enters information into both these fields along with other data. My problem is that I need the begin and endDates that they enter to be broken up by months. For example...

I'm trying to design a database for my company that calculates interest paid on a loan based on the number of days there is left in that month. For example, if a loan is taken out on Jan 27, they have to pay 5 days of interest for that month (including the day the loan is taken out). So i'm...