Search results

Is it possible to schedule meetings/appointments with outlook contacts in Access 2007? I've tried Google but a lot of the results are about using Outlook instead of Access 2007. I don't need it to schedule resources (such as a conference room) or a specific meeting time. I just need it to send...

I don't know where else to post this question so forgive me if I placed it in the wrong topic. I have an Access 2007 application with some pretty complex VBA code, subforms, forms, SQL Server back-end, etc. If I was to recreate this Access 2007 application to a mobile/tablet app (Android or...

I have a subform that is a data entry form and I read on some other forums that when you press Enter, it will act like a Tab key and move to the next field. I want to program a textbox so that when you do press the Enter key, it will fire some code. I can't get it to work because Access sees it...

Hi there, A linked table is showing a field with either a '1' or a '2' for Yes/No. In my report, I set the format to Yes/No. When I run the report, all the records displays a 'Yes' regardless if the data is a '1' or a '2'. Does anyone have a quick solution to properly format it to display a...

In my report, there is a textbox that displays the Buyer's name for a purchase order. The Buyer's name is determined by the first two digits of the purchase order number. Dim Buyer As String Buyer = Left(Me.PurchaseOrder, 2) If Buyer = 23 Then Me.txtBuyer = "Buyer1 Name" End If If Buyer =...

Does anyone know if it is possible to have a button that will hide/unhide columns in a continuous form and rearrange them? For example Current Continuous Form |Column1||Column2||Column3||Column4||Column5||Column6| Then when you click a checkbox or something, it looks like...

Hi there, I am ultimately trying to create an INSERT that will add a record to a junction table, retrieve the MAX row_number partition by Audit_ID and ID (<--identity) and store it into a variable called SortNumber. Then I will use the SortNumber variable to update the record with a sortorder...

This is a cross-post from dbforums. My boss wants a Netflix-like queue feature on a continuous form. The user will select items and add it to a 'checklist'. This 'checklist' is a continuous form. The user should be able to sort the continuous form results by adding a rank to each result (like...

Hi there, I am able to use Application.FollowHyperlink to open files on the network drive but I wan't it to be read only. For example, if they open a Word Document I don't want them to edit anything and save the file. I can't make permissions for read/write access because the users need to be...

I saw a solution that involved using multiple transparent textboxes, but this won't work because the color only shows when the textbox has focus. Does anyone know a way to have more than 3 conditions and have the colors always show? Thanks!

I want to import the outlook contacts information into a table. I went to External Data --> Import --> Outlook Folder --> Folder. I choose link tables and then create a linked table. When I open the table, everything seems correct except for the email addresses. Here is a sample email address in...

I am trying to retrieve text from a textbox and store it into a table. I am getting a Too Few Parameters error and I can't seem to find a way to fix it. I've tried all sorts of suggestions on Google but it doesn't seem to be working. The problem occurs with the 'Audit_Scope' parameter. If I...

I have a table with Audit_ID as the primary key and I am trying to open a subform and have it load the record where Audit_ID equals a global variable called AuditID. The AuditID is an integer and the Audit_ID field of the table is also Number (or smallint in SQL Server). When I try to execute...

I have a continuous form with many rows and columns. Is it possible that when a user double-clicks a cell, then it will pass the value in the cell into a textbox? Thanks for the help!

I need to search a textbox for a piece of string and then store that string into a variable. For example: If the textbox value contains "Jane Doe, John Doe (Audit ID: 0337) 01/12/1991 Scheduled", then I would like to put the Audit ID "0337" into a variable. The textbox value will always...

I am trying to insert into three SQL Server tables. The first insert will go into the Audit table so it can generate an Audit_ID. Then using that Audit_ID, I will run a For loop to insert (Audit_ID, Auditor) into the Auditor junction table and (Audit_ID, Auditee) into the Auditee junction table...