Search results

ohhhhh, why? please let me know... im new to Access. your ideas or knowledge is highly appreciated. Thanks a lot.

but how can i incorporate this one to my command: =CLng([SearchResults].[column](33)) :)

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 John, My apology that I know its kinda late to react on your previous post here but I just found out that the reporting button you gave me "PREVIEW REPORT CURRENT RESULTS" gives me all the records in the database and not the current results. Example: Searching for "Australia": it...

i tried to several comboboxes in my DBS but nothing happens.

Access 2010

it has 16 and i changed it to 5 but still a lot of spaces below the record. number of rows in the entire table is 4,000+

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 :)

thank you JHB. i tried it and it worked.

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...

the main form has a different row source, thats why i dont know what to do that the box should have a separate/different row source from the main form.

hello John, i followed everything BUT theres a problem in your sample. eveyrthing is in a form while mine is just inside a box. attached photos are provided to make it more clear. im having a problem where to put the TABLE as my row source, take note mine is just a box (inside a form) not a...

Hello John, will try this sample DBS of yours. Thanks a lot!

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...

i second the motion.

yes that is correct - my fields will go higher or will keep increasing as time passes because i still have records left. i stopped encoding/putting it when i realized that my listbox number of records decreases. attached are snapshots of my database: 1st: Query ; 2nd: Number of records...

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...

you must be a cool guy... welcome aboard!

i got it. its not CInt (integer) but CLng (long integer)... Thanks guys!

i changed it and it gives me this error : #Num! <--- instead of numbers. i leave the format to Standard with 0 decimal.