Search results

Hi JHB, Feeling little embaresed to ask... Well I am very new to access vba and dont have much idea with regards to variables. Hence, requesting if possible could please give me a little more insight about the variables... Thanks, Rakesh

Just for the information while i execute the given code i get runtime error as 3420...

Many thanks for the reply... just an additional requirement... I tried ur code but afraid nothing seems to work....hnce looking for further more help... Additional what i am looking at is after clicking a button on the form all the headings of the coulumns should get populated in the list...

Hello, It would be great if anyone can help me for the below mentioned requirement. I have a table which has around 25 columns having unic headings (tble name - Worked_File). All I need to do is populate only the headings of all the coulumns through a button click to a list box. Thank you...

Oh God!!! Before starting up this tool i thought this would be a cake walk but now m realizing its getting more and more complicated :banghead:. Anyways, one last help....is it possible.....to make multiple users see one unique record i meant if 10 users are using the copy of the tool at the...

Hello, Been trying to get the force save done....but so far been a good looser in doing it.....i am really confused how to proceed further...... Attached is the access file which i have done so far, requesting to please have a view of it and guide me for what else do i need in order to get it...

An access table having more than 70,000 records (line items), needs to get processed. In order eliminate scrolling of data I executed a SQL query which will show only 1 record (line item) at a time, once after processing the record and after clicking refresh the next new record will reflect...

Hello, Well I want to create a access file which would happen to be one of the database for my organization. My question is which way would be the best way to share the access file among multiple users. I tried doing split database but unfortunately i figured out, that same record is...

Hello, Below are the fields that i have in the "tblWorked File"...... [Date], [BO_Name], [BO_STATUS], [BO_COMMENTS], [BUSINESS PARTNER], [ORG_NAME], [ORG_COUNTRY], [ORG_CITY], [ORG_LANGUAGE], [TELEPHONE_CRM], [STREET], [DISTRICT], [POSTL CODE], [WEB SITE], [ORG_TELEPHONE], [ORG_FAX]...

Hi, Requesting help for the below mentioned: Can we update the user name/computer name into an exisiting access table for the top 10 records via SQL query. If yes, then please help me in building the query else requesting to provide suggestion for further alternatives to update. Table...

Hello marlan, I did the same way as you instructed but unfortunatly i figured out that all the users are getting the same record for process at the same time. Hence, in order to avoid that I thought may be if i can execute the autofilter then my problem would get ressolved. Hence...

Hi Isskint, Thanks for the revert... Just for the knowledge i have 30k data which needs to get processed by around 10 users at the same. Hence, for the first question I believe the autofilter should happen everytime. And from the user prospective, all the users will open the access file...

Hello, I have a form dirrectly linked to a table. The table has a particular column which has only unique Ids (Lets say the column name as "ABC"), to be shared and processed by multiple users later on at the same time. All I want to do is execute a autofilter vba code on column "ABC" so...

Hello, Many thanks for the revert.... The query which i have used to show 1 record out of 70k record is SELECT the fields required to show...including Name and date FROM the Specific table WHERE Name is blank ORDER BY a certain unique ID And on the query i created a continuous form for the...

Hello all, An access table having more than 70,000 records (line items), needs to get processed. In order eliminate scrolling of data I executed a SQL query which will show only 1 record (line item) at a time, once after processing the record and after clicking refresh the next new record will...

Hi JHB, Many thanks for the response... But afraid to say that I am not getting the desired result, if I place "computername()" and now() as DefaultValue for the properties fields of the form. It's in fact not showing both system name and date in the form. Is there any other way possible...

Hello All, Requesting help for the below mentioned requirement.... I have two textboxes which is populating the system name and date, and the same is not getting recorded in the specific table's row. Hence, requesting in helping me to build the vba code in order to record the data. Note: I...

Hi, Thanks everybody for the help. Lastly, requesting a little more help for the below mentioned requirement... How can i capture the computer name into an existing table which has a multiple form too... thanks Rakesh

Hi, Thanks for the help.... Mean while it would be really great if could help me a liitle more in doing an "AutoExec Macro" since i very much new into the field of macros of ms access... Thanks, Rakesh

Hello All, Requesting to please help me for the below mentioned requirement... I have a access file having a form and a table all i need is a code or some guidance in buiding the code in order to "recognise the user name in the computer environment and the same must get updated automatically...