Search results

Where can I find that Data Entry property? I use DoCmd.GoToRecord , , acNewRec an it work, but I want to know also how DoCmd.OpenForm "YourFormName", , , ,acFormAdd works.

I already tried that but it only clears the text box and the other fields. But when you type entries directly to the field without clicking a button to start for a new record then it will just edit whatever the first stored record in your table. Is it may be possible to attach a code on the On...

Hi, I noticed in MS ACCESS that, if you associate any bound or unbound text boxes fields and combo boxes fields to your table then those fields will automatically show up the record from the table from which those fields are associated with. Now, what if I want to keep those field blank...

Thank you for all the informative advise, I learn so many things about access today. May god almighty keep you safe and shower you more blessings and your family. Thanks also to those who shared their thoughts regarding this post. Sorry if my english is not that good like you guys, until then...

Lord Almighty! Thank you very much isladog, Genius... I can sleep well now, God! I love this forum. :D:)

Inside the Employee Details form, if leave one of these combo box blank such as the Department, Position or the Office Location and hit save the record is not showing on the ListBox below even on the query. But it appears on the database table.

Thank you @isladog for helping me out to get rid of those errors. I checked out the new file and it worked perfectly fine. But there is one thing that I noticed, I tried to enter a record but leaving one of the combo box blanks and when I click save it didn't appear on the list box below. But...

Thank you very much for your help, but unfortunately, I cannot check it right now because I'm out of the office. I will message you back as soon as I check the file and of course if I have another thing to clarify :D

I don't mean to confuse anyone I'm just trying my very best to illustrate my point, I just thought it might be helpful if I post some the important part of the database so you all can get my point quickly. And I think the best way to illustrate this is to have guys check the database file...

I think you need to remove the lookup table from your query Alternatively it might work changing the inner join to outer I am not sure if I get your suggestion clearly. Because as I have stated above, all the record source are coming from the table and not from the query. I can send you the...

Yes, the "Device Type" is one of those lookup field which is preventing entries to be saved on the table if I leaved it blank. Actually I have the same issue on my other forms which I did not disclose it here since their having the same problem, what I mean by that is, if we solve the problem on...

Hi, I attached three files which are captured from my MS ACCESS database. I just want to make the data type as optional and able to save the entry even if the devicetype field is empty.

Here a glimpse on how I connect my tables. Tables 1. DeviceList 2. DeviceType 3. Employee Details DeviceLists Table *ID *DeviceName *Brand *DeviceType -------- Connected to my device type table *ModelNo *SerialNo *EmpID ------- referenced to my employee details table. that is the summary on...

Hi, The Required parameter is already set to "NO" I just checked now. Is there any other setting that I might need to change to solve this issue?

Hi, I have a form with many combo boxes, and the problem is, if I leave one of any of those combo boxes as blank then I get an error message says. You cannot add or change a record because a related record is required in the table 'Table Name'. Is there any solution to save an entry even if I...

Thank you for the quick response @June7, the problem is solved.

SELECT DeviceList.ID, DeviceList.DeviceName, DeviceList.Description, [Device Type].DeviceType, DeviceList.DeviceBrand, DeviceList.ModelNo, DeviceList.SerialNo, DeviceList.MacAddres, DeviceList.PurchaseDate, DeviceList.CheckoutDate, DeviceList.Status, DeviceList.Note, [Employee Details].FIrstName...

Hi good people, I'm having an issue in generating Query from a multiple table source. I have a table called "DeviceLists" and within that table, I have two fields named DeviceType and EmpID which are connected to my DeviceType and my Employee Details table. Now the problem is, every time I make...

I'm sorry, I didn't think about the bound column. It is working now thank you very much.

Hi, I'm new to MS access, and I would like to do an experiment on how I can filter a report based on the selection from my combo box. I've watched so many tutorials but it seems like I'm having a hard time to follow it. I did even follow one tutorial from youtube and did exactly what the video...