Microsoft Access / VBA Forum

Using Access database: I want to shorten a string of text into abbreviations. I have a table with all long text and associated abbreviations and am having trouble with how to implement it. Example: "take one tablet by mouth three times daily" should read "take one tab PO TID" using a table that associates "tablet" and "tab", "by...

I have 3 fields in my Staff database. First Name; Last Name; Full Name. I want to Concatenate First Name and Last Name fields to STORE/SAVE in Full Name fields at frmStaff on tblStaff.

Hi buddies need your help once again. a virus .kasp attack on all files i renamed the access file but its still not working and showing unrecognized database format. how i can repair file.

In MS Access, when coding in VBA to show a string of any Unicode language (e.g., Arabic or Urdu, Persian, etc.) in a message box or textbox, it is changed into a strange language, e.g., �äÏÑÀ ãÇÑ�¡ Ïæ ÀÒÇÑ �Çä�-. Is there any solution for this other than going to settings/control panel and setting an alternate language for non-Unicode languages?

Hi Folks. I have a simple insert statement only four fields. The last field "Table" is the problem child. IF I take it out and the associated value "Me.txtTempTab" the insert statement works. Image of code also attached. Any assistance would be greatly appreciated. Thank you in advance... DoCmd.RunSQL "INSERT INTO tblScrBldSched " & _ "(...

al ejecutar db.Execute "INSERT INTO BaseDatosMatriz" _ & "(,,,,," _ & ",,,,," _ & ",,,,,)" _ & "values( Form!,Form!,Form!,Form!,Form!," _ & "Form!,Form!,Form!,Form!,Form!," _ & "Form!,Form!,Form!,Form!,Form,Form!);"

Hellow friend... I have a folder in my Google Drive... Here is an Excel File name Correspondence. it contain the record of incoming / outgoing letters which are in pdf format. These pdf are also stored in the same folder in Google Drive... I want to create Hyperlinks in this excel file. Then I want to give the Link of this excel to any one...

Im looking for a time picker for Ms Access that has cmd buttons 0-23 for hours and cmd buttons 0-60 for minutes so for example if it was 13:00 you could just press 13 and 0. How could this be done or is there an example out there? I did see one that used toggle buttons but couldnt figure out the code. It had for minutes a button for every 5 min...

Hi. Apologies for any incorrect/off technical lingo. Fairly new to Access and would appreciate any help! I'm trying to create a command button that will filter form records based on an already created query. I have a main form with 100 records. Each form record is an employee at a company. The main form was created from a table of the 100...

I have an Access Database that is reading data from a SharePoint list, then outputting the data into an excel spreadsheet There are many queries involved, about 40 total. Here is the format of each query: Set qdf20 = db.QueryDefs("<Query Name Here>") qdf20!Param1 = Param Set rst20 = qdf20.OpenRecordset() ...

Good day MMcCarthy Please I'm a beginner in Access programming. I'm developing a small application for my office use. On the Form, I would like to have some fields diabled based on selection from a combo. For instance, immediately after selecting Cars in a combo, the fields Tonnage and AuxTank should be disabled; preventing user from entering...

Hi, I am using Access 2013 to do this. I am trying to come up with a way to export multiple tables/queries to different excel or text files automatically when a user pushes a button on a form (one file per Table/Query) I would need the user to be able to choose the file layout and the destination Location for the exports. An example...

I have an Excel file that uses VBA to open an Access database in the background and run a macro that refreshed tables in the database. Once this is complete, then there are steps done in the Excel to refresh data linked to the Access table, copy, paste, etc. The Access has slowed a bit with a server change and now the macro takes a little...

suppose i need only to validate year range for period that is 2014-2016 like this format. it shouldnot accept the value period 2020-2016. how can i give my period first given year should be greater than second given year. kindly help!

I have a fixed with txt file that has multiple data specifications in it. I am using MS access 2013 to parse out the data. Is there an easy way to apply the different specifications to the file without having to build separate queries in Access to parse it out?

I have a Form Where i Need to see Values from a another table's field so i have created a lookup field, that works perfectly but i wish to filter that lookup list with values which are not yet Added?? Table -- TblSup Field -- SCID Table -- TblRec Field -- LPSCID i have a lookup list from TblRec!LPSCID field so i can view values...

Hey buddies i create a form and a report i am using signature image on report through form i made a checkbox ... now anyone tell me please how to VBA code to hide or unhide the signature image in report ............. not in form......

i am beginner dont understand coding very well, i saw a post in which i get code but i dont know it will work or now and i dont know how to use it in VBA. can anybody teach me ? Option Compare Database Option Explicit Sub Test() Dim TestDate As Date TestDate = CDate("11.04.2013") Dim dtString As String dtString =...

I have three tables and would like to export them into one excel sheet. One table will be from column a to e and second will start from column g and third table from k. Please let me know if it is possible.

Hi. New to Access and would appreciate any help! I'm working on a Multiple Items form and want to populate the date field in the 2nd, 3rd, 4th, etc. line with the date selected in the 1st line. Example: 1st line = 7/25/20 2nd, 3rd, 4th, and on = same date

Need some help/pointer. I am attempting to search a table/field to see if it matches a field in a form. This is not working for me. I am just looking to hard, but reaching out. If Me.Txt_field = DLookup("", "Table", Preset_variable) Then 'found it Else 'didnt find it

I have a report that needs to track the total time spent on a project daily. I have converted the hours to minutes, and am using the Format( Mod, "\:00") to convert them to hours & minutes. One person has 360 min +420+420+450+270 = 1920 total minutes which divided by 60 = 32 hours --- the report shows a subtotal of 32.30 hours?? There are no...

Im trying to restict user from certain groups and only allowing them to fill in certain fields. but it seems that the code i have allows all user to enter data can some one help me. the code < Option Compare Database Private Sub Form_Load() 'dim the control Dim ctl As Control 'If the user is in admin do not lock the fields. If...

I am working on patients' record database, which I made using Access 2010. when I open it in Access 2016, its theme gets changed altogether. I fixed it by saving 2010 theme by using 'SaveToFile' method and then updating theme in Access 2016 by using Themes > Browse for Theme.. in 'Themes' portion of 'Design' Tab. I Want to open that Browser...

Right now I can generate a report that groups data per each sub group. I then export them to individual PDF files by a VBA code. So the report with group ID 555 generates with group 555’s data and so on. I need to add generic full pages to each group document. I tried a few things but it doesn’t really work. I’ve ran into random problems/glitches...