Search results

Try changing it to this: ="[Formatted Cost Code]=" & "'"&[Forms]![NameOfFormA]![Formatted Cost Code]&"'" make sure you change the form name to the name of your FORM A

When are you setting your global variable?

Here's what I use for connection to SQL Server, perhaps this will work for you: This is for a cloud database Public Sub openConnection(p_conn As ADODB.Connection) Dim l_sqldbname As String On Error GoTo connect_error Dim str As String Dim DatabaseName As String Dim ServerName As...

Re: Why I got "Run-time error '9': Subscript out of range" when using acOutputQuery? Try using Docmd.TransferSpreadsheet instead of OutputTo. You can't OutputTo the same excel file twice.

How are you having users select multiple records to print? Are they printing from a datasheet and just highlighting the rows?

I'm sure you may have done these steps already but putting them out there anyways: You don't have a backup of it anywhere? Even on the clients machine? What about your recycle bin. Check your recycle bin for any previous versions you may have had. Have you done a search on your development...

Not sure why you wouldn't want to put the funding source in the main table? If you have one of only 3 funding sources you should create a lookup table that lists all 3 funding sources. In your main table just have a FundingSourceID column bound to a combo box on your main form. If it truly...

hmmm...not sure on that error. Are you sure that is an error or is it putting in that value in the table?? When do you get the error, just when trying to save the table after putting in default value? Or is this error in the form?

This line is the problem: If (Me.Metric_Display) = 0 Then 'attachment metric_display is an attachment type field so change it to this: if (me.Metric_Display.AttachmentCount) = 0 then

Yes, you should be able to put it in the table.

Yes, I agree with @gemma, the database does not sound like it is properly normalized, however if you must maintain those values you can do it in the datasheet. Go to the datasheet form design view and then bring up the properties for each of the Fields 1 and Fields 2. Find the property called...

Here is a thread from this forum that may help: http://www.access-programmers.co.uk/forums/showthread.php?t=99713

The SQL Server Group name will not change when you change the AD name although it should continue to associate with that AD Group which is why your users still have permissions. You would have to go in and Re-Add the groups if you wanted the names to match the AD names.

Are you just trying to avoid having to type the 1111 and Contract in the table fields each time you add a new record? Do you have other values that would also go into field1 and field2 besides 1111 and Contract? Or is your entire database going to keep those same values?

can you post your query syntax?

Did you recently make changes to the form in question and are you printing to different printers? If so that particular form may have saved the printer settings from a different printer. Also, check the form in question width and height properties and compare it to your other forms. It may...

I think the error might be in the actual report. Can you try to open the reports from the navigation pane and see if you get this error? The code above seems okay to me.

Is the combo box bound to a particular field or are you performing logic in VBA to save the record back to a table? I would check the field you are saving the combo box values to and make sure that the field type and size are correct for the value you are selecting. If that's not the issue...

You want to set focus to it after the report opens. DoCmd.SetWarnings False DoCmd.OpenQuery "UpdateMasterInvoice", acViewNormal, acEdit DoCmd.Close acQuery, "UpdateMasterInvoice" DoCmd.OpenReport "Invoice", acViewPreview, , strWhere, acWindowNormal, strOpenArgs DoCmd.Close acMacro...

Here's another one: http://www.pcreview.co.uk/forums/access-2007-email-template-help-t3775215.html