Search results

Oh! And I'm using Access 2013. Sorry!

I am trying to do a macro to do the following steps. 1. Open "OpenClaims" Form 2. RunMenuCommand "Find" 3. If no search item found then Close "OpenClaims" form 4. Open "MRIClaims" Form 5. RunMenuCommand "Find" In layman's terms I want a macro to open the 1st form let me search...

Thanks, I'll give that a shot! Looks like what I need. Kathie

OK, I tried to see if this was possible but not finding much of an answer. So I figured I'd check with our merry band of experts if it even is. I'm using Access 2013 and I have a database I would like everyone to be able to see but only those that have a password to be able to change data...

Thanks for the options. I'm a newbie, so learning as I go. Simon, I'm still playing with anchoring, though none seem to be doing the trick. Haven't use it before so it's sort trial and error here. Gemma, short of changing my own resolution is there setting I can change in Access 2013 to be...

I've created a form in Access 2013 on my computer which has a screen resolution of 1280 x 800. Now when I look at it on another computer with lower resolution, which others also will once this goes live, it obviously gets cut off. So just wondering what is the best size to make this form so...

I'm actually trying to combine 2 spreadsheets that this company uses and create a database with the least impact possible. For now I want to keep the spreadsheets as seperate tables, making the transfer of the data as error free as possible. Not trying to keep a running total but more keeping...

I’m pretty sure this possible but I’m just not finding a code that works. Here’s what I am trying to do: I have a form puling from one table and then a subform in that form pulling from another table. I have a field in the [FORM] called [GROSS REFUND] and a field in the [SUBFORM] also...

Works perfect now!!! No problem if it's blank because if it's not on the list we should be selecting anything anyway. Kathie

Ok so that sorta worked. But it changes the drop down for all the records.

I may be overlooking the obvious. Here is the situation We are assigning Tablets to Vehicles based on their location. I currently have a dropdown box pulling the Tablet Numbers and their location for selection. [Combo182] I also have a text box where we type in the location of the...

Kinda figured that, we have a report that lists the employee's number but then just last name. We don't need first names for everyone, only those with the same last name. Like we only have 1 Smith but 2 Jones, so only the Jones would need to have a first name attached.

Hi all! Before I do too much research I figured I'd check if this is even possible, since you guys are AWESOME. I'm using access 2000 to maintain an employee database. There are some times where I am using just last names but need to distinguish between those with the same last name. I...

Alan! You are the BEST!!!!! Something so simple but it was alluding me. Worked perfectly! Kathie

Hi all! I have two queries with the same columns that I would like to combine into one. eg: [End Times] query retruns 4 results and [Pickup Times] query returns 4 different results. I want a new query to list the results from both queries resulting in 8 results. Through research I know...

Thanks for both of your solutions. When I talked with the others in the group about the solution I originally found and that I was waiting to hear what this forum had to say, they liked my original solution first. They liked the idea that the information was only viewable by those that...

Hi all. What I want to do is have people be able to view an Access 2000 database but ONLY those with a password be able to modify it. Like in Excel and Word. I know I've seen methods using user groups and such but our problem is that for the most part everyone uses the same logins. Strange...

Thanks! I looked a little further at the menus and managed to find exactly what I needed. This forum sure is a life saver! Kathie

Before I try to research this too much I thought I'd as our wonderful group here if this can even be done in Access 2000. I have one database I use to keep track of all my school runs, kids, and drivers. Another co-worker has a database that has all the vehicle information. What I'm...

OK I'm just not seeing this. This is what I need to do with 3 checkboxes: When either Checkbox [Monday Prog1] or Checkbox [Monday Prog2] are checked, I need the [Monday] checkbox checked. Then likewise unchecked with the same criteria. I tried doing a bunch of different codes in the after...