Search results

How can I have a user input data into a form and it save the input data into a table? The table currently has data in it, and I do not want the user to be able to view/edit data that has previously been input. How would I set this up?

How can I filter a form based off the value selected in a combobox using the afterupdate() event of the combo box?

I have a table that has a itemId column, then another table that has the itemName. I created a form for the table that has the itemId, so numeric values are displaying on the form. How can I have the form "lookup" or display the itemName so I have a meaningful name on screen for non-technical...

I am attempting to use this to filter a sub-form frmSaleItems.Form.Filter = "[ItemId] = '" & Me.Combo7 & "'" but i keep getting this error Datatype mismatch in criteria expression What should I change in that vba line to remedy this issue?

have a user form where a user must input a text value. I am wanting to check if the input string is 2 words ore more, and if the input string is one word. What I need is if the input string is 2 words or more, then I need to take the first character from the 1st word and 2nd word. If the input...

I have a user uploading excel workbooks to a website, where data is then inserted into MS SQL Server tables. These SQL Server Tables are linked tables into MS Access Database. I need a way that once records are inserted into those MS SQL Server Tables to run a MS Access VBA Module. What would...

This should be basic but I can't figure it out. I want each page to only show data for one Test. Each time a second Testdisplays I want to go to a new page. My desired display is Header 501 ------- Logo 1 Then page TWO header 501 ----- Logo 2 Attached is a sample databse with a...

I receive a spreadsheet that is imported into access, and it needs to be manipulated to make columns out of some of the rows, and get counts for locations. Attached is a database that shows with two tables, the Received which is the direct spreadsheet import, and the needed which is the table...

I was initially having issues with my barcode not displaying but I resolved that, now my issue is the barcode won't scan. I'm using the 3of9 barcode. Attached is a sample database, with scrubbed data. Does anyone here see an issue as to why the barcode is not scannable? I tried to upload here...

I'm sure this can be done, I just can't wrap my mind around doing it. I want to pass in a sql string to a Function that will open a recordset and return the result of the recordset to the calling function. I'm trying to do something like this Sub Test() Dim sqlString As String sqlString...

I am wanting to create an excel workbook and write a record set to it. I have my recordset, and I have created an excel workbook. But I am not sure how to write the recordset to it. This is the code that I have. Dim rst As DAO.Recordset Dim userSQL As String Dim xlBook As Object Dim xlApp...

Does Access 365 have the ability natively to add a barcode to a report? Basically take one of the fields from the query that is the control source of the report and convert it to a barcode?

I have an excel worksheet that in column A has an IP Address, and column B has a userid. If the user visits the same site multiple times, obviously there would be multiple entires in the worksheet for that. I need a way to get rid of all duplicates. Sample data is like this 11111111 a12...

I found this awesome post http://rondebruin.nl/win/s1/outlook/saveatt.htm - but my question about this is, must the access database be open in order for this code to execute? I'm needing a solution where the access database does not have to be open

Using Access VBA can I download ShareFile attachments?

Through some assistance here and through google, I have copy/pasted a frankenstien of some code together that does exactly what I need. My question tho, is if there is any ways of cleaning this up, or am I using any bad practices/principles that could/should be changed? Thanks in advance to...

I have one last requirement that I need. And that is to create an excel pivot table from access vba. Using the macro recorder in Excel, thhis is what it generated. How would I change this to run with Access? Sub Macro2() Sheets.Add...

I am altering a spreadsheet from access vba. I have this Excel macro that makes a portion of the required changes, but this is excel vba not the access vba. Can someone provide me with what this code would look like if it were access vba to control excel? Columns("H:I").Select...

I need to concatenate the rows in my workbook. I want to ignore column A, and only do column B - the value of lColumn I am capturing lColumn like this Dim lColumn As Long lColumn = wb.Sheets(1).Cells(1, Columns.Count).End(xlToLeft).Column Which means I want to take column B - lColumn and...

I have a text box on a form, with a button. When the button is pressed it opens a File Dialog Browser, and allows the user to select a file to input. I can not make the text box any longer, so as a work around I was wanting to show the furthest right of the text (file name and extension) I am...