Search results

when it crashes and gives me the option to debug, when i mouseover the statements below my UPDATE, i see where all the components have a valuee

here is my form and table. all im trying to do is grab all my info from the form and write it to the database. im wondering if the value in my WHERE clause affects my query being that it is an autonumber.

i have a query that is driving me crazy. Table Name is USERS and the structure of my table is this: UserId - AutoNumber FirstName - text LastName - text UserName - text Password - text Level - Text Active - Yes/No im trying to update with this query: DoCmd.RunSQL "UPDATE USERS SET FirstName...

i just set the forms as pop ups, works great

point me to one because all of those ive seen so far only tell me how to close all forms. i wanna know how to close this form not the main form

is it possible to open a form in a new window of sorts ? i have a form called main, i have 2 buttons that open 2 forms. on each of the forms to be opened i have a close form button. when i close an opened form, it closes main as well. how can i close the opened form without closing main ?

im all about trying so im gonna try what you suggested @Pat Hartman

this is if the form is a bound form. what i did was to requery the form after update and in the onClick of the button, after the query, i requery my id combobox me.cboCusids.requery. this works for me.

oh i c. hmmmm

is there a way to run my project like an application ? ive already selected my display form and hidden my forms tables and such. is there a way to run my project without being able to do anything else in access ?

thanks. thank you so very much

i have a customer form that allows me to add and view customers. the thing is that after i add a customer, it does not allow me to view it right away, i have to first close my form and reopen before the recently added customer is accessible. is there any fix for this issue ??

ive already figured out how to load a form as access opens, so is there a way to force users to use the forms and deny them access to the tables ?

got it fixed bro. its working now. strange as hell but it works now

oh that .... lol .... i was the one who changed the report name in my experimentation. remember i had originally said that the subreport keeeps coming up blank ?? i apologize for uploading the wrong version of the file. so now that the report is coming up correctly, how do i get the...

bro, no idea what ur talking about. plz remember im in the learning process. all ive learnt n done so far is by trial & error, experiments n reading. can u fix it ? did you get it to work ? where do i find attached macros ?

i have a report rptGeneralCustomerInformation which is linked to a form and gets an ID. i have a subreport called qryGeneralPartnerInformation subreport1 that also requires the same ID from the form. i have both reports created but im having issues. the the report works but the subreport...

thanks alot guys fixed those issues.

how do i wrap information on my report ? i have a query that returns 26 fields but they are all places in the same line in my report design. how can i change this ? Also, is it possible to drag the various pieces of information to anywhere on the report to kinda setup my report the way i want it ?

Active is an integer variable. i just realized i had set its datatype to string. i fixed that just now and the issue is still the same. Active is being written to a lookup field YES/NO