Search results

Thanks Do you have any tips for getting the back end to handle the refresh? I know how I want to do it but I have the following problems, 1) The backend isn't open, so how do i get it to do an on timer refresh? 2) how do I get the backend to refresh the queries in the front end without moving...

Hi Guys, I need some help, or pointing in the right direction. I have a database that 30+ people are using over 4 departments. Department 1 raise an order improvement and assign it to department 2. Department 2's interface (a subform running off an on timer update query) refreshes and...

Thanks guys, feel stupid now lol

Hi All, I have a query with 4 "or" criteria. The problem is the assigned to values are ignoring the "<>" criteria that I've put in. I've attached a pic of the design view and the SQL code below. INSERT INTO tbl_ISDreplies ( ID, [Part Number], [User] ) SELECT Tbl_ReqType.ID, Tbl_ReqType.[Part...

Hi Guys, I have 2 sub forms. One subform for showing new work and one for outstanding. Both subforms are hyperlinks with the below code to enable the user to open up the form they relate to. DoCmd.OpenForm "Frm_logRequest", acNormal, , "ID=" & Me.ID Both have this code on Click on the text...

Thanks Steve, Thats helped and I've made a note of that address to read. You've helped me out and pointed out error checking that I hadn't even thought about. Many Thanks

sorry forgot to mention tbl_deptform has two fields. the first is the ID which is a number and the second is "department form" which is a txt field that houses the form name. my end goal is to find the ID from the user and then from the ID find the form name to open for that department.

Thanks Steve, moving on I have now added a second part to this. I've changed the data type of department1 to Long as it is returning a number and I want to match this in the second dlookup to return the form name. I did some reading and saw that if you want to match two numbers, you just...

Hi Guys, I have a database with multiple main menus. this is across 3 different departments,and depending on your job depends on the main menu you can access. I'm working on a log in screen that will read your username and will open the main menu for your access level. I have a table...

Thanks Minty

Hi Plog, I'm sorry, please allow me to explain. 1) The users that will be using this access database that I am creating will not know how to run a query. 2) I want to set up a query using some default values say X, Y and Z and then have them be able to select a further set of values to add to...

Hi Guys, I have the following code I found online to help me create a query using check box controls so the user can add the values they require. I have slightly modded this code. Option Compare Database Private Sub Command0_Click() On Error Resume Next Dim ctl As Control Dim strSQL As...

Hi All, I'm designing a database to keep track of improvements on orders. I want the "user area" form to have a subform showing all their improvement requests. I want this to be set by controls on a form. 1) The records will always be linked by the Username to make sure they only see their...

Apologies, Please see below https://accessexperts.com/blog/2015/02/04/how-to-open-your-ms-access-application-like-a-custom-software-application-ms-access-tutorial/

Hi, Sorry I don't think i explained myself well enough. I can hide the ribbon and the navigation pane. Please see the below link. This is the kind of thing I'm after, but this only works as long as you dont switch to another program and then back to the database.

Currently using Access 2010

Hi Guys, I've got a couple of access databases that are in use at work. Over the weekend I saw a video whilst doing some research of an access database that the user had up. This looked like one of those custom software jobs, you couldn't see the access program window at all. I have seen a...

I had the Dim as String as I was using an Inputbox Continuation = InputBox("Please Enter the Continuation Reference") Is there a better way to do this as I still get a syntax if I take off the single quotes.

Thanks Minty, Adding the syntax has helped, now its pulling up the Dlookup with a data type mismatch? As a primary Key, the Continuation ref is an Autonumber and the Shikomi Parent number is text

Not quite, the Continuation is linked to the Key, so the DLookup is there to lookup the key from the continuation