Search results

I am a beginner I have two tables: tbltasks & tblsafety Both tables have a date field in, one table keeps tracks of my tasks the other the expiry date of some safety checks. I currently have a timed pop up that looks at dates within a table that are within 30 days from now, if there are any...

Hi Firstly Im a complete beginner I have a table called "tblWorker" which contains my login information: WorkerID | WorkerName | LoginID | Password | UserType ------------+------------------+---------------+----------------+----------- 12 | Jonathan |...

Paul Yes basically I mean its not doing what I want when I load the login form and enter login details always returns, Run-time error '13': type mismatch. Unfortunately I dont have the skills to really make sense of your reply this is the problem I have. When someone sends me amended code Im...

Paul db attached I hope. literally just trying to get this Login Working Thanks Jon

Paul Ok sorry about sencond post wasnt sure if I had posted in right area. Not sure how to attach a db

The Fix message read: you can fix the code by combining crtteria LoginID and Password in one criteria under one DLookup. Jon

Hi Firstly field and forms names are correct, the system highlighted that code in red and the user I downloaded it from has posted a note to say that part of the code is not quite correct which ties in with the error, the problem is I cant really undertsand the fix its a note on YouTube...

Hi Only a beginner so have been reading many threads and kindly using sample codes to build my database. I recently downloaded some code to create a simple login form with an option to load a different etc for Admin or Users. When I tried to run the code I keep getting some of it highlighted...

Hi CJ Thanks for coming back, unfortunately I am a beginner with access so struggling to make sense. I have quickly created a new database just to practice this combo issue rather than mess up my main database. This is what I have table 1 is called mastertable three fields all text (saved...

Help needed, cannot sort this out :banghead: So I have a very simple database I have two tables, table one (Master Info) holds a list of property addresses & information this is my master list containing all the property addresses I use. The second table (Property Info) contains various fields...

Hi Firstly definitely out of my depth as only beginning to build databases but getting there slowly. I am trying to do the following: I have a form that I enter when safety checks are required for some property i manage, I then have a report that displays a summary of all the property and...

Help My combo boxes are not returning the actual combo box values back to my table, instead in the table it is displaying the combo box data list number i.e 1,2,3,1,5,1 etc where it should be displaying a property address if that makes sense grateful for any help Jon

Paul, Thanks exactly what I wanted. So simple been searching for hours.

Hello, Basically I want to open the folder and show the contents of that folder so the user can then select any files within that folder themselves. Thanks Jon

Sorry to ask such a basic question. I am simply trying to create a command button to open a folder on my desktop Cannot seem to find this code This is the path to the folder I want to open C:\Users\JONATHAN\Desktop\CMS FILES So grateful for advice Jon

I want to have 2 combo box on my form. 1 where you select store number and the store name will appear in a text box 2 where you select a plu code and the plu description appears in another text box. Have done my tables. Have created one combo using wizards which finds the store name based on...

Ok Having problems with combo box. I have 2 tables: store info and Plu Info In store info there are 2 fields: store name & store number In Plu Info 2 fields: Plu Code & Plu Description. I have a form to input data and search from combo boxs etc etc. I have created 1 combo box using the...

Hi people getting on ok with database but cant remeber how i display info in one text box based on what i enter in another box. Here what i nned to do: I have a table of store number and store names. I want 2 text boxes. when a user keys in a store number to related store name apperas in the...

Hi, Haven't used access for a long time and very rusty on things. Hope someone can help: I have a table with store numbers and store names. I want a form with a text box that when i enter the store number the appropriate store name appears in another text box. It seems simple but im going...

Hi Guys Ok, i am near finishing my database ready for it to go to work, but i would like to know if it is possible to change the top bar on the database, that says Microsoft Access, it is in blue and is the actual program name and has a icon of Ms Access. I have seen other database where a...