Search results

Not quite behind you But trying to catch up. I'm not quite certain how to implement this -- I'll give you an example. If I am opening the EditRecord form from the BrowseRecords form, I might do something like this: DoCmd.OpenForm strForm, , , strLinkCrit, , , Browse to set the word Browse...

How can I tell which form is open programmatically? I have a form used to update records - and these records can be accessed from one of two forms. After the update process has run in my code, I want to send the user back to the form from which they came - but I don't know how to identify...

Found A Solution, Still Wonder Why I managed to get this to work by changing the query from a stored query to defining it in the code. I went from doing this: Dim strQueryComments As String strQueryComments = "qryUpdateServiceComments" DoCmd.OpenQuery strQueryComments To doing...

Wayne, That worked a treat -- thank you very much. If you have the energy/inclination, I would love to hear the "whys" -- I am a code newbie and am trying to cram my brain with as much knowledge as I can. I particularly like that I don't have to set focus to check the values; I use this logic...

I am trying to check the value on a check box that corresponds to another checkbox on the same form. Here is the code I am using: With Me .chkNewIndefinite.SetFocus .chkNewIndefinite.TripleState = True If .chkNewIndefinite = Null Then...

I am running an update query, using unbound controls on a form to gather the data. One of my unbound controls is a text box that I use to write to a memo field in the table. When I try to write more than 127 characters, however, the query fails and returns the error "Invalid Argument." Any...

Binding the control is great, unless you want to use an unbound control. I'm afraid this doesn't answer the question, which is why is there a limit on the text I can enter in a text box on a form, and how can I work round that with an unbound control.

I have a memo field in my table, with unbound text box on my form that I use to write back to this field, but the text box on the form limits my data entry. Any ideas? I can physically go into the table and add the data, and view the data in the text box, but I can't add beyond 255 characters...

I was asking, not paraphrasing, but at any rate, I am really curious how I can make these faster. The service names are such that I can't use first letter. Ex. I have service names "Upper Ottawa" and "Ottawa Valley", thus I could use an "O" as index character, but not first letter, because I...

I'm interested to know more .... Partial string searchers are therefore more expensive than wildcard searches? Where can I read/learn/see about using indexes in a similar search? In the present environment (a relatively new database) I have less than 1000 records in any of the relevant...

I don't follow, sir. For example, I have a query that goes like this: PARAMETERS [Enter Service Name] Text ( 255 ); SELECT DISTINCTROW tblService.ServiceID, tblService.SupervisingOfficer, tblService.ServiceName, tblService.ServiceType, tblService.Attn, tblService.LiaisonOfficer...

Greetings all I am just working on some parameter queries, and am wondering if anyone has done any benchmarking with instr vs. wildcards? Instr appears to be a more elegant solution, but is there any solid performance advantage or disadvantage? My apologies if this should rather be in the...

Greetings, I'm not sure that I understand exactly what you are after, but... Try changing the format of your list box to a text box, with the data source set to the same field as your combo box. Text boxes in reporting formats tend to work pretty well.

Thanks -- I see it working there -- I was trying to use the existing report, but obviously it works. Other problems with the tables - - yes! The database is a bit of a mess -- I'm trying to cobble it together to get it working, but am tempted to start over -- I didn't include all the tables in...

Here is the stripped down version of the database - -no names show in the report because I haven't included the table. The times - -and the error - come up. Use the form to launch the report if you like -- the query will prompt you for form, and "Seniors Take Charge" is the project with the...

Nope. It's spelled correctly. If it were only that easy.... Still doesn't work, still returns the #Error. I've even changed the field names to remove the space to make sure I am duplicating the name properly.

Thanks Rich, but this gives me #error as a result....

I've just inherited a database problem -- aren't I the lucky one?! In a project tracking database, we are tracking time spent by employee on a project. For individual projects, we have a query that totals the time each person has spent on this project, as follows: *********** SELECT...

1) You can use House Lettings if you like for your table name. I try to avoid putting spaces in my table names, because I am lazy and it makes it easier when you write queries and reports. Use a noun that describes the data that goes in the table. For example, a table that has employee...

What is the identifier on your main form? As far as my experience dictates, whatever link you use to create your relationship between your primary form and your first subform, you need to use also for any subsequent subforms. For example, if on your first tab you have a JobID that relates to...