Search results

Gave the error =[CONTRACT_TBL]![HULL_NO'.

I just encountered this problem. I have 25 columns. It worked when I limited the number of columns for the report. Not sure. I guess its a bug in access. Has anyone else encountered this issue.?

hmm Let me ask this, Is it possible to put the default value on the table itself. Rather than the form aka, [CONTRACT_TBL]![CONTRACT_NO] I tried or attempted to put it in the default value box within the table. The one where data is being placed into

oh and yes. the field has been locked!

haha I didnt see that. default value. Thank you! close this session pls

database will retain field 1 & field 2 the same throughout the table. all other fields will either be combo boxes, input. The fields are also locked so user input will not be able to change. I dont want user input to change anyhow. I dont want any user input to fields 1 & field 2

Going to ask a dumb question on here. Brain fried for a day. Trying to maintain Data for a datasheet We are trying to maintain the data throughout the datasheet table. Meaning that Field 1 Field 2 Field 3 Field 4 1111 Contract Apples Carrots 1111 Contract...

Ive also tried some random things like mytbl: [electrical_data] (using the masking in the query not the table) works great then I add in mynewtbl: [mytbl] && [full_description] output is 4806003. is it possible to keep it in the same field, masked

http://www.access-programmers.co.uk/forums/showthread.php?t=240699

I've tried something like this, MynewFieldNameHere:Format([electrical_data],"!000\V/00"Ph"/00"Hz";0;_") gives me an invalid syntax error. Is it possible to make a field, and requery the same field in a query

thanks pat. I appreciate the response. I have decided to put the data in a query, but having issues pulling the input mask. see this link below.

I've tried subquery but not sure of how to use the zoom feature with expressions

update. I was able to make a separate query with the input masks it works, but can you query a query.... and a specific column

I have a nice laid out query, trying to keep the masking fields. aka !000\V/00"Ph"/00"Hz";;_ sample, 480V/60Ph/03Hz when I use my query to concatenate the fields, it comes out as 4806003 how is it possible to keep the fields with the masked inputted data? with the !000\V/00"Ph"/00"Hz";;_ sql...

well I was able to get what I wanted it to do, but, it is not retaining the masking part of the field. Is that possible for a lookup field?

I am doing a lookup wizard for a table. I was wondering if it is possible, I know its possible in a form but again trying in a table. I have a parts table in the parts table is a field called electrical_data a number will be entered into the table aka 1 I have a electrical table...

Having an issue for ensuring all tables and forms are web compatible. we are getting this error for web checking. I have attached the zip of the db ... I know I can use a generic navigation form from access 2010 I like this switchboard very much. it works very nicely. it is only...

First I have to extend my appreciation for those that have been working with me the past couple of weeks. I am looking to transfer my tables from my blank database tables to a web database for access 2010. In the process I am creating some new tables for the transition. How or where the heck...

yes thanks baldy, I wasn't sure if the post would be seen since it was added to a late thread.

Ah thank you.. Working on learning sql.. Much much appreciated. Will make life useful!. And save me some hunting on the web have a super duper day. I hope others in the future will make use of it. I am using baldy in my reports, whomever wrote it.. I thank them.