Search results

im doing a database for CV (curriculum vitae) of employees. i have a challenge in adding records (Working Experiences) in a same person. i have a button in a Form says Add Record but when I add a record it will go to the next entry (in Table). does anyone knows here how to work this that...

I have a Report that has inconsistent data - inconsistent in terms of number of characters; some have longer text, some have less. I set the format to Can Grow so those characters with longer text can adjust automatically. it works perfectly, but my concern now is I wanted all unbound textboxes...

I have a listbox in my database to show the items filtered from comboboxes. But, I could see several blank spaces on the right most part whenever I scroll my database on the right side. Can anyone help me how to delete those blank spaces? by the way, i have correct/exact column count already...

i have 2 combo boxes. 2nd combo box is dependent in the first combo box. values work perfectly fine. my problem is that, these combo boxes are in a Form that will add new records, once a new record has been added the item in my Table shows a number not the exact word. For example: Combo Box...

i have a pop up form that users need to fill up whenever they need to Add New Records. everything is working fine. BUT, what should i do that in the next time the user will click the Add New Records it will not show the previous items that have been added? since it is added in the Main Form...

Hello All, I need suggestion on how to organize my Tables, Query, and Forms in order to have a better database. I have been told by one of the members here that I have done a lot of things that is not right in my database. What I am doing now is how to filter my drop down button. first drop...

Is there a possiblity that a control CAN be edited that is bound to an expression? All of my Form properties are set to editable, no locks, allow deletion, allow addition, etc. I just want a text box in a Form to be edited by users if they want to update it but they CAN'T since it is bound...

anyone knows what should i do or codes should i put? my problem is that, there are 3 drop down button that should filter category of items in a database: Category 1 Category 2 Category 3 whatever users choose in category 1, it will filter the items in Category 2. whatever users choose in...

Can anyone direct me to a sample database where its about Time In and Time Out Attendance. If not, can anyone give me an idea how to do this? It will just calculate the difference of Time In Time Out with employees Card Number. The Time In and Time Out attendance is provided (no data entry)...

Experts of Ms Access I need your help again... I posted my concern way back in this forum but still I cant get it work. I need your help again. The problem is that, I wanted to work on changes of calculation per row. I attached a photo to make it much clearer. In Design Engineering: If...

Hello everyone, im having a problem about my DBS. there is a calculation in the Query then amount or total will appear in the Form. there are some items that doesnt have information in the Table, so obviously calculation wont be involve in that specific item. now, if theres no information to...

hello everyone, i have a database that needs a manual input from the user for X, Y, Z range. i need help on deriving a code ( "maybe" in query for criteria? ) that tell if the user exceeded on the allowable number range of either X, Y, or Z. for example: X = should have a value of 5 up to...

Hello everyone, can anyone help me? I have a combo box that will get values from a different table or query. i am having a problem with the query and the row source on what to write so i could get values from the table/query. i tried with the resources i gathered but still i dont get the right...

Hello Everyone, i have a problem regarding some of the boxes of records in my database. i have a command in every box of my DBS: =CLng([SearchResults].[column](33)) my DBS has lots of records, some box have entries some do not have. so my problem is that if the box has no record it will...

Hello everyone, I am having a problem how to solve my combo box drop down. I wanted it to have no spaces or no extra rows below the last record whenever the combobox is clicked and scrolled down. BTW, I attached a picture. Thanks :)

Hello everyone, Just want to ask: I have forms, and buttons going to the other forms. Whenever I click the button going to the next form, the previous form is still on the background. What should I do that the previous form should be totally out of the picture whenever a new form is clicked...

hello everyone, im having a problem with my combobox. i tried everything but it seems that i could not find the solution. attached is the photo to explain everything. i have 1 combobox with 5 records in it (Class 1 - Class 5). Whenever a user click a specific Class number the 3 boxes below...

hello everyone, just want to ask what are NESTED QUERIES? i have a database that involves lots of fields in the query. before, it has only 32 fields in the query but now it has 43. by the time it went to 43 fields, some records arent showing up in the listbox. maybe i go beyond the...

Hello everyone, I have a problem regarding the thousand (number) separator or the "comma" in my Form. I already tried Standard, Currency, Fixed but still the number in thousand looks like this - 12345.67 , i want it to be 12,346 (round off). I even tried replacing Standard in the Property...

i have a database that requires money conversion. for example, everything is in USD, then there is a button for GBP then every calculation or input will be converted into GBP rate. default right now is USD. is this possible? if yes, how? Thanks. :)